Open form to record for date from another form

[Gfunk13]

I have a button on one form that closes the current form and opens a new one. I would like the new form to open and go directly to the record with the same date as the record that was open on the previous form when the button was pushed.

GoToRecord requires a specific pre-determined date or record number. I would like this to dynamically determine the date.

I have also tried to apply a filter, but I don't want to filter the records on the new form. I want all records available, but to go directly to the record with the date from the previous form.

 

[maxhugen]

Look up help on the docmd.OpenForm method. You could pass the date in the OpenArgs.

In the second form, in the OnLoad event, you can use the form's RecordsetClone to find the record with that date, and go to it.

Let us know if you need help with that.

Max Hugen
Australia