Pop Up Form for Contact Details when double clicking contact image on Contact List

[Madi]

I'm very inexperienced with access but am trying it out to create a vendor/ contact list for work. I have created a form (VendorList1) from a table with all the contact info (auto id, company name, image, address....). What I am attempting to do, is create a Pop up form (named Profile) with the contact details that appears when I double click the image (in field 1) in the original contact list form(VendorList1). I have already created the pop up so that is ready to go, I just need help with figuring out the code for opening the pop up with the details of the company whose image I am double clicking. Thank You!

[dashiellx]

In design view on your form, under the Event tab for the image control's properties you should see a line with On DblClick. Click the button on the right to open the VBA code window or create a macro using the drop down.

[Madi]

In design view on your form, under the Event tab for the image control's properties you should see a line with On DblClick. Click the button on the right to open the VBA code window or create a macro using the drop down.

Yeah I found that, what I need help with is the the code to put into the code builder

[dashiellx]

Sorry about that.

DoCmd.OpenForm "frmFormName", ,,,,acDialog

[Madi]

So actually I figured out the command button to open for form so that solves half my problem. My issue now is that when i lick the open form button next to the company i want to see the details for, it opens up the same page every time. How do I make it so that when I click on the open form button next to a specific vendor, it brings up the profile form with that vendors info and not the first record?

[dashiellx]

You want to use the WHERE clause of the OpenForm method.

DoCmd.OpenForm "frmFormName", , , "[CompanyID]=" & Me.txtControlWithCompanyIDonForm, , acDialog