Subform from query not updating

[wilkob]

I have a form in which I have a date field.
In this form there is a subform linked to a query.

The query should show the number of shipments which have the date in the form as shipment date.

One way or the other the query works, but the subform does not show anything when I open the form and enter a date in the date field.

Can someone help me out here?

 

[sportsguy]

in the afterupdate event on the date control,

Me.Mysubform.Requery

will requery the subform to access the new information

sportsguy

 

[wilkob]

Hya,

Thanks for your quick response. I have now set the event in the afterupdate control, but the following error message
"Microsoft Access can't find the macr Me."

The date field has a default date: =date().
can I also have the event in onload or on open?

 

[wilkob]

changed the form completely....
based on the query I have a continuous form that now shows me the readyshipments for the day.

In the query I have set a criteria [please enter date] that pops up before opening the form - which shows the shipments.
Still the question remains: can I not add a date field to the form which is linked to the query and once a date is entered the ready shipments show on the form?