Sending Form data to query criteria...thread702-794545

[buzzboychicago]

thread702-794545 is kind of what Im talking about.

I have a small form with to date pickers...
and have referenced those in the query...
Between [Forms]![Form8]![StartDatePicker] And [Forms]![Form8]![EndDatePicker]

If I open the query...the query does actually display records in respect to the criteria that I chose on the pre-filter form.

However, If I try to open the form thats based on that query, I get a popup asking what those two fields are. Does anyone know why this is? how to remedy it?

Thanks!

 

[PHV]

When the query is launched, Form8 must be opened, otherwise the popups come.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[buzzboychicago]

I have it open...im not sure the form is seeing it though.

 

[PHV]

Is it open BEFORE the form based on the query ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[buzzboychicago]

yeah...i figured it out...

I brought all the data up a level (it was in a subform) and I put it in the main for and tried it again and it worked without prompts.

Does anyone know if its possible to direct the data to the subform.

I am assuming it has to do with the order in which things are queried or focus or something.

this will work if i don't find an answer. Thanks for your help though.

 

[LowBrow]

I think the reference is Forms!Form8.subformname!control.

 

[PHV]

[Forms]![Form8]![Subform control name].Form![StartDatePicker]

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244