Creating Multiple SubForms From Queries Using User Input

[mhaase]

Hello. I am trying to have a Form where a user inputs a date and then the Form creates 4 subforms usings queries from a table based on the input date from the user. I am new to Access so I am open to different ideas if there is a better way to do this.



To simplify the problem, how would I do just 1 subform in a form from a query that took user input? I have included an image of the form. The user would enter a date, press the Display Planner button and a query would be made to a table, that would then display in the PayableWeek1 subform.

Thanks in advance for suggestions/advice!

[kd2017]

Have your queries reference the date picker control and code the button to just requery the subforms

https://btabdevelopment.com/how-to-u...ia-in-a-query/

[mhaase]

Ah... the re-query step was where I think I was having a disconnect. I got it working! Thank you!