run a query using a selected date

[iso96]

hello,

I want a query to run and output values on a certain date. I have created a form and inserted an activex component 'Microsoft Date & time picker'.

But im stuck on how to get this component to be recognised by the query! Can anyone please help me out or suggest a different way?

thanks

iso

 

[nicola1]

If i understand you correctly, this is what i would do.

On the field where date and time picker is picked from, make this an unbound fieldie no recourd source. On you query under the relevant field for example date_time, for the criteria put:

Like [Forms]![your form name goes here]![the name of your unbound field goes here]

If i understand what you asking for that should work