Open a form to show only dates from the originating form

[NadiaWilkes]

Hi everyone.



i have a single form with several fields and one of the fields is a date field. On that form I have a button that opens another form that basically contains the same data only in a continuous form so that I can see all records, not just the one record on the main form. When it opens I want it to only show the records that contain the same date on the single form I have open already. Eventually there will be records for various dates but if I am on a record and open the form I only want to see the continuous form records with that same date only. TIA

[isladogs]

Add filter criteria to the code used to open the new form. Something like this ...but using your form, field, control names

DoCmd.OpenForm "NewFormName", , ,"MyDateField = #" & me.DateControlName & "#"

If you press the F1 key whilst you click on OpenForm, Access help will open and give more info

Another method is to use Me.FilterOn=True followed by Me.Filter = "MyDateField = #" & me.DateControlName & "#"