Form and Query

[Daryl2106]

Hi,

I have two questions:



First, I am trying to get a query to return records between a certain date range. In the form I have DateFrom and DateTo unbound text boxes from which faculty select the date range. I know I have done this before, but I cant figure out how to create a field name and write the criteria for the source query in design mode! I tried [Form]![FormName]![DateFrom]<[Form]![FormName]![DateTo] in the criteria but I can't seem to write a valid field name that doesn't alter the criteria in some way...

Second, in the same form, faculty enter the StudentID for the student they wish to get records for. How do I write the code to show a msgbox when there is no such ID in the event they enter an StudentID incorrectly.

Thanks in advance.

Take care,

Daryl

[Dal Jeanis]

You have two different SQL criteria:

[DateFrom] <= [MyTable].[MyDateField] 
AND 
[DateTo] >= [MyTable].[MyDateField]

So, in query design, you can have one criteria line for MyDatefield that says

>= Form!FormName!DateFrom AND <= Form!FormName!DateTo

Optionally, you can put square braces around Form, Formname, and the control names. Mandatory if you use spaces in your form or control names.