How to return a selected row from a datasheet popup

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I want the user to be able to click on one specific row in a datasheet popup
and then return the entire row to the calling code for processing.

Questions:
How does one identify the row the user has clicked on in the popup form?
How best to return the selected row to the calling code?

Sorry if this has been asked and answered but I searched for 2 hours and
couldn't find much.

Thanks in advance!
 
The best way to identify a row is my its Primary Key value (usually and ID
field) If the form is still open and the record is selected, you can just
refer directly to the text boxes on the form:

Me.txtMyText = Forms!Forms2!txtMyText

If the form isn't going to stay open (even if it is hidden) build a
recordset based on values in that record, from the ID (primary key) stored
in a global (public) variable.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to return a selected row from a datasheet popup form 1
Select row in a datasheet subform 2
Referencing a datasheet row 1
Lock datasheet rows for values 1
Datasheet question 2
How to Address Rows of a Datasheet in a Subform? 2
Force form to open in DataSheet view 1
Subform Select record 1

Back
Top