Use a popup form to select a record in the primary form

[bashtonmcse]

Over the years I have created a pretty good computer asset database in Access. In the primary device form I have buttons to display different types of devices using popup forms in datasheet view such as server, workstations, routers... I would like to add functionality to these popup forms that if I double click on a device in the popup form it will close the form and refresh the primary form with the record I double clicked on. I have started doing more programming of late in access and suspect I know parts of it, but also realize there may be multiple ways of doing it. Some suggestions on the best way would be helpful.



Thanks

[Perceptus]

You could change the openargs that are called to the popupform to track what record will be updated in the popup. Read the openargs in the form loaded event, and store it in a private variable to the form. Use the double click event for the "device" in the popup form so that it uses the variable to know what record to update and then close the form.

[bashtonmcse]

I don't think I explained it very well. The primary form displays device records with all the detail information. On this form we have several command buttons that open forms that display data in datasheet mode. We are not trying to pass parameters for a specific record to the called form. Each called form is filtered by a device type such as server, router, pc... What I am trying to do is that when one of the pop up forms are opened that the user can double click on a record in the form and have that form close and change the current record on the original form to the record selected in the popup form.

I have gotten part of it to work, but the problem comes to the exiting of the form. When the popup form closes the focus is still on the original button. If I put the code to change the record in the click event it happens immediately upon clicking the button to open the form which is before a record is selected. If I put the code in the exit event then it will not happen until the focus on that button changes to another object.