Running a query from a form

[JimmyRa]

I have a 'query form' which asks the user for dates, some codes, etc, and then runs a query based on these. The query uses [ >= GetStartDate() and <= GetEndDate() ] functions to retrieve the screen entries. Worked fine for a while, but now gives me a 'last operation was cancelled' messagebox every time I hit the RUN button on screen.
Any ideas where to start.

 

[randy700]

How about...

Between GetStartDate() and GetEndDate()

 

[LarryDeLaruelle]

Jimmy:

Are you referencing the form's controls in the query or are you building the query using SQL?

If you are referencing the form controls make sure you fully qualify the reference:

Forms!frmName.ctrName

If you are using SQL, make sure you bracket the date fields with pound signs:

" . . . >=#" & ctrName & "# and <=#" & ctrName & ". . ."

HTH

Larry De Laruelle
ldelaruelle@familychildrenscenter.org