How can I get criteria in my queries to refer to a form?

[LMcleod]

Hi,

I'm not familiar with forms in Access. I have designed one called parameters with the intent to use it as a 'criteria' form i.e have users type in their criteria on the form, and my queries to read off the criteria selected in the form.

I tried putting [forms]![parameters].[Start Date] in the criteria in my query, but Access doens't like it. [Start Date] is simply a Label in my form, if this makes a difference.

Any help would be much appreciated.

Thanks

 

[SiJP]

I have the following criteria entered in a query:

Between [Forms]![frmAccountReports]![txtDateFrom] And [Forms]![frmAccountReports]![txtDateUntil]

Basically it refers to two fields on the form frmAccountReports..

Try changing your

[forms]![parameters].[Start Date]

to

[forms]![parameters]![Start Date]

(Exclaimation mark before start date!)

Good luck.

 

[LMcleod]

Silly me! I didn't name my Text Boxes!!

 

[LMcleod]

Thanks for your help Simon - just made a silly mistake.