Im using Access 2003 & have a form which has a list of people (frm_Quick-Search), next to each record is a command button (QuickViewCMD) which fires up a pop up form ("frm_quick_view") so the user can see notes on the person. This all works fine but I have to close the pop up form each time that I want to look at the next person. What I want to be able to do is either
When the persons mouse hovers over the Command Button the form opens up and closes when the mouse moves away.
Some how close the last instance of the form and reopen it to show the relevant record (this might be impossible as the pop has to be opened first & needs a link to show the correct records in the first instance)
Use the logic of ... if frm_quick_view is closed then open where ([people_id]=" & Me![people_id]) If its open change the link ([people_id]=" & Me![people_id])
Private Sub QuickViewCMD_Click()
On Error GoTo Err_Command59_Click
Dim stDocName As String
Dim stLinkCriteria As String
stDocName = "frm_quick_view"
stLinkCriteria = "[people_id]=" & Me![people_id]
DoCmd.OpenForm stDocName, , , stLinkCriteria
Can anybody help???