Data entry form to open relating to selected record when a button is pressed.

[david.paton]

I have a list box on a form called SearchResults and I want to be able to click a button and for the data entry form to appear for the record that is currently selected in the list box so a record can be edited. How do I do this?

 

[Ranman256]

Docmd.openform "myForm",,,"[id]=" & me.searchResults

This only works if the bound column is the key id. You can hide the id field by setting the column width =0. The Other columns stay visible for the users to see.