We help IT Professionals succeed at work.
Get Started

Automated Pop up Form

Tom Crowfoot
Tom Crowfoot asked
Last Modified: 2013-11-28
Dear Experts

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

    Exit Sub

    MsgBox Err.description
    Resume Exit_Command59_Click
    End Sub

Can anybody help???
Watch Question
Most Valuable Expert 2012
Top Expert 2013
This problem has been solved!
Unlock 1 Answer and 3 Comments.
See Answer
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE