Form/Subform with Parameter

[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?

 

[KARL DEWEY]

Did you put the parameter in the query that feeds the subform or somewhere
else?

 

[John W. Vinson]

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 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)

rather than prompting for the criteria.