Synchronizing Pop Up Form with main form

[JimJones]

Hi,

I have a pop up form that displays the result of a query.
That pop up form shares the CustomerNumber field with the main form.

The pop up form works properly in that whatever record is displayed on the main form, the pop up form goes to the correct one.

But, when I scroll forward or back on the main form, the popup form does not synchronize with it.

Any help on that, please ?

Thanks,
Jim

 

[Mile-O]

Have a look at this:

 

[Mile-O]

Forgot to say that it isn Access '97 and, if you are using a different version, the RecordSetClone property may need changed to RecordSet.Clone.

 

[Pat Hartman]

You need to reference the main form field as your criteria for the pop-up form's query. Then whenever you scroll the original form, you need to requery the popup. You will also need to make sure that the pop-up is open before requerying it.

 

[JimJones]

Mile-o-phile and Pat Hartman,

I just wanted to say thanks for the sample and the help.
I am beginning work on this task now, as I was working on something else earlier.

Jim