Open record from sub form

[paulcraigdainty]

I have a form with a sub form. The form allows users to enter data into the database and the subform displays all records in the database. I want users to be able to click on one of the records displayed in the subform and that record to display on the form in the format it was entered.

 

[pbaldy]

One fairly simple way is to use the same code (using bookmarks) created by the combo box wizard, using the "find a record..." option. Put that code in the appropriate event, changing the various references to the appropriate form/subform controls, etc.