Form/Subform with Parameter

  • Thread starter Thread starter manatee08
  • Start date Start date
M

manatee08

I have a form with a subform, the Link Child Field and the Link Master Field
are set to MasterID. The subform contains actions due and all is working
great. However, I want the subform to contain a parameter of: Between
[BEGIN DATE ] and [END DATE] and only show the actions due between these two
dates. The problem is that it is asking the parameter question each time I
move to a different record. Is there a way to have every record reflect the
parameter of the subform and only enter the parameter one time?
 
I have a form with a subform, the Link Child Field and the Link Master Field
are set to MasterID. The subform contains actions due and all is working
great. However, I want the subform to contain a parameter of: Between
[BEGIN DATE ] and [END DATE] and only show the actions due between these two
dates. The problem is that it is asking the parameter question each time I
move to a different record. Is there a way to have every record reflect the
parameter of the subform and only enter the parameter one time?
Click to expand...

I would suggest putting unbound textboxes named txtBeginDate and txtEndDate on
the main form and using a criterion such as
= Forms!YourMainForm!txtBeginDate AND < DateAdd("d", 1, Forms!YourMainForm!txtEndDate)
Click to expand...

rather than prompting for the criteria.
 
Back
Top