Hi John, I Answered My own Question!! I copied the form from another and using the Validation Text kind of as a placeholder for some info (Don't ask me why!!)' When I cleared it I got it to work, but my question is why would info in that field stop it from working?
Thanks Joe -- In [email protected], "eliotchs" <[EMAIL PROTECTED]> wrote: > > Hi John > > I closed the DB, reopened, went to th Report and still got no prompt. > > The report opened with #Error in the data fields? > I did the same thing with Listbox values, and it works fine? > > Thanks > Joe > > > --- In [email protected], "John Viescas" <[EMAIL PROTECTED]> wrote: > > > > 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: [email protected] [mailto:[EMAIL PROTECTED] > On Behalf > > Of eliotchs > > Sent: Monday, January 09, 2006 1:23 PM > > To: [email protected] > > 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/
