Synchronizing From a popup

[Greyfleck]

I have two forms. A property form and 'select address' popup form. If they select an address from the pop up I wish to populate the main form with their selection. I have beaten myself up over this for far too long and would really like some help. I have tried it with a query and requery, AND as it is now, having the popup as modal and changing the rowsource based on the data eturned all without success.
I am happy to email the zipped (96k) extracted database if anyone can help.
Many Thanks
Jon

 

[PHV]

In the Open event procedure:
Me.RecordSource = "SELECT * FROM Properties"

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[Greyfleck]

No joy sadly. To be sure I put the command in the Properties form open event.

The data still failed to display. I tried using me.filteron = false too but that just bought up the first record not the one I was looking for.