Joe- If the form is open, you won't get prompted.
John Viescas, author "Building Microsoft Access Applications" "Microsoft Office Access 2003 Inside Out" "Running Microsoft Access 2000" "SQL Queries for Mere Mortals" http://www.viescas.com/ -----Original Message----- From: ms_access@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of eliotchs Sent: Monday, January 09, 2006 1:23 PM To: ms_access@yahoogroups.com Subject: [ms_access] ?? on dialog on a report ?? Hi, I have a report using the following SQL: SELECT Month([doi]) AS [Month], Year([doi]) AS [Year], [Location Code].Location, Client.TypeClient, IIf([IncidentData.Restraint] =1,1,0) AS Rest, IIf([incidentData.PoliceType]="1",1,0) AS PolN, IIf ([incidentData.PoliceType]="2",1,0) AS PolE, IIf ([IncidentData.IncidentType]=1,1,0) AS AwolES, IIf ([Incidentdata.IncidentType]=17,1,0) AS AwolNES, IIf ([IncidentData.IncidentType]=2,1,0) AS Abuse, IIf ([IncidentData.IncidentType]=3,1,0) AS AssltStaff, IIf ([IncidentData.IncidentType]=4,1,0) AS AssltClient, IIf ([IncidentData.IncidentType]=5,1,0) AS SexMis, IIf ([IncidentData.IncidentType]=6,1,0) AS Alcohol, IIf ([IncidentData.IncidentType]=7,1,0) AS Weapon, IIf ([IncidentData.IncidentType]=8,1,0) AS IllPhy, IIf ([IncidentData.IncidentType]=9,1,0) AS Injury, IIf ([IncidentData.IncidentType]=10,1,0) AS SuicideAtt, IIf ([IncidentData.IncidentType]=11,1,0) AS Suicide, IIf ([IncidentData.IncidentType]=12,1,0) AS Death, IIf ([IncidentData.IncidentType]=13,1,0) AS IccDose, IIf ([IncidentData.IncidentType]=14,1,0) AS IccMed, IIf ([IncidentData.IncidentType]=15,1,0) AS WrongTime, IIf ([IncidentData.IncidentType]=16,1,0) AS MissingMed, IIf ([IncidentData.IncidentType]=18,1,0) AS IllMed, IIf ([IncidentData.IncidentType]=19,1,0) AS SelfInj, IIf ([IncidentData.IncidentType]=20,1,0) AS Other FROM ([Location Code] INNER JOIN (Client INNER JOIN IncidentData ON Client.ClientID = IncidentData.clientid) ON [Location Code].[Location Code] = Client.CurrentLocation) INNER JOIN IncidentType ON IncidentData.IncidentType = IncidentType.IncidentType WHERE (((Month([doi]))=[forms]![ReportsMenudivdir]![cbomonth]) AND ((Year([doi]))=[forms]![ReportsMenudivdir]![cboyear]) AND (([Location Code].Location)=[forms]![ReportsMenudivdir]![cbolocation])); My WHERE parts doesn't seem to work. If I run the query, I do not get prompted for Location , month or year it just runs? Am I not supposed to be propted even when I run the query? Is it different for Running reports and forms? Thanks In Advance Joe Yahoo! Groups Links Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/ms_access/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
