subform

[doug]

i am using a form with a subform that displays records
based on the id and date on the form. The date is
controlled by the calendar control. the subform displays
the proper data on entry of the form, but i want the
subform data to change based on the date i select on the
calendar control. could anyone direct me as how to do
this?

thanks
doug

 

[doug]

it is based off a query, and i did put that docmd.requery
in the after update but nothing happened. it almost seems
as if the after update is not firing.

also with the master child thing, i can use the subform
field but how do i set the master to the calendar control
on the form?

thanks

 

[Van T. Dinh]

Post relevant details of the RecordSources for the
Mainform and Subform, the Calendar Control (is it bound?)
and what you have set for the LinkMasterFields &
LinkChildFields.

HTH
Van T. Dinh
MVP (Access)