Subform based on between parameter

  • Thread starter Thread starter David
  • Start date Start date
D

David

Hello,

I would like to make a form where there will be two fields
and a subform. The two fields will be a beginning Date
and an End Date. The subform will would be based on these
parameters. I have seen similar post, but I'm missing
something. If anyone can help with this.

I know how to achieve this in a query but would like to
have it in a form with a subform.

Thank you
David Ehrenreich
 
I would set the between on datasource for the subform, then after update of
the begin and end dates requery the subform.

HTH
Kat
 
Hello,

I would like to make a form where there will be two fields
and a subform. The two fields will be a beginning Date
and an End Date. The subform will would be based on these
parameters. I have seen similar post, but I'm missing
something. If anyone can help with this.

I know how to achieve this in a query but would like to
have it in a form with a subform.
Click to expand...

Just do it as a Query and base the subform on the Query. I don't
believe that you can use a "between" as a Master Link Field!

You may need to Requery the subform in the afterupdate events of the
beginning and end date controls.
 
Back
Top