sub form how to?

[pdbowling]

Hi all.

I've got a subform that I would like to populate in the Form load event.

I have a parameter query already written that I would like to use to fill this subForm. The parameter is a date [#Enter Date#]

I'd like it to default to now()

The form prompts me for the date in the parameter query (as it should)

How do I assign now() to the parameter in the subForm on load event rather than typing it in?

I already tried writing the query as a string in the on load event and assigning the record source of the subform to the sql statement but it's too complex so it won't take it.

Thanks all.
PB

 

[stardusty]

PB, Does =Format(Date(),"Long Date") work?

Brent