Query won't reference a form

[d-mcc56]

Hey all.

I'm trying to get my query to reference a form (frmCCC) but instead it prompts me.
In the criteria for one of the fields I have type "Between form!frmCCC!txtStartDate and form!frmCCC!txtEndDate.
To my knowledge it should open up the form but instead it prompts me to input twice with respective labels form!frmCCC!txtStartDate and form!frmCCC!txtEndDate.


I read somewhere that this occurs if the form isn't loaded, I've tried opening the form before running the query but still nothing.

Any help?

Thanks

[ranman256]

its FORMS!frmCCC!txtStaraDAte

always use the BUILDER. (the magic wand icon) it will spell things correctly.

[d-mcc56]

Ah I'm embarrassed. I changed it and now it tells me the expression is too complex to be evaluated