Quote:
Originally Posted by HowHow
Access 2000. In a form, I have a subform showing simply names and contact numbers. I need a pop up contact form (related contact detail like job title, address, email..ect) when double click on a specific name. This pop up form will not show other contact person but will allow me to do editing or deleting on that specific person that I double clicked only.
How to do that?
Assuming you have a numeric unique id for each person, say, Person_ID, then put a button in the detail section of the subform that opens a new form, say, frmFullDetails, that has all the fields you want to edit.
Then in the click, or double_click event of this button, use the code
-
DoCmd.OpenForm "frmFullDetails", , , "Person_ID=" & Person_ID
-
