Populating Continuous Form

[gagnonconsulting]

I am working on an application where the user selects a date from a calendar form and the matching records from a table are selected and listed in a continuous form along with a button to do something to the record. I have been able to make the calendar and the part that the user can click a day that has data associated with it and I have this data available in a DAO recordset, but I cannot figure out how to get it onto the continuous form. I have researched and found that the continuous form must be bound to something, such as a query, so I built a parameter query using the QueryDefs object and set its parameters and that part works, but I am not able to bind the form data to the resulting recordset.

Maybe I am doing this the wrong way, but it seems that selecting something on one form and being able to display multiple records on a second form based on the parameters selected on the first should be doable. Any help would be greatly appreciated.

 

[dave_m]

Can you store the selected date in a field somewhere on the calendar form, have the other form's query data source use a parameter that looks up the value of that field, and manually call .Requery on the second form when a date is selected?