populate a hidden text field of a form from a datasheet

[ricobano]

I have a form with a button that pops up a datasheet with a number of records. I need the dbl click event to populate a hidden text field with the id of the item that was double clicked.

Ive found the double click even and can get the double click to close the window, but i need to populate the text field as well. Any guidance is appreciated.

 

[boblarson]

I have a form with a button that pops up a datasheet with a number of records. I need the dbl click event to populate a hidden text field with the id of the item that was double clicked.

Ive found the double click even and can get the double click to close the window, but i need to populate the text field as well. Any guidance is appreciated.

I assume by hidden text field you mean a TEXT BOX. Fields are in tables and queries (which include form and report record sources) but CONTROLS are on Forms and Reports.

You haven't shared much to be able to be specific but essentially, if the record you double click on has the ID field included in the form's recordset, you should be able to set a control like

Forms!FormNameHere.HiddenTextBox = Me!IDFieldNameHere