Subform based on between parameter

[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

 

[Katrina]

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

HTH
Kat

 

[John Vinson]

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.

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.