How to return a selected row from a datasheet popup form

[Guest]

Sorry if this has been asked and answered, but my two hours searching didn't
find it.

I have a main form that launches a popup form in datasheet view.

I want to be able to have the user click on a specific row in a datasheet
popup form and then return this row to the form that launched the popup so
that I can use some of the data from that record to fill in textbox controls
on the main form.

I don't know how to identify which row in the popup the user has clicked on.

I also don't know how to return that entire row to the calling code.

Any suggestions will be greatly appreciated.

 

[Graham R Seach]

John,

See if this approach helps:
http://www.pacificdb.com.au/MVP/Code/MyDialog.htm

Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia