CODEWITHSUNDEEP
ms-accessvbams-access-2007
SunRay
SunRay

Reputation: 200

Opening up a seperate form in a continous form

I have a continuous form that my users would like to view. It is shown as below.enter image description here

I want to allow the user to open up a more detailed form by click on the swab locations that are specific to the asset ID. Let's say user clicks on MFG 0252. A window with the following should pop-up. I am not sure how i can go about this. Is there a way for hyperlinks to do it? or other other methods which are better?

enter image description here

Upvotes: 0

Views: 37

Answers (1)

Cisco
Cisco

Reputation: 251

on the OnClick event of your button:

docmd.OpenForm "tblMainSwapLocation",acNormal,,"[Asset_ID]='"+ Me.[Asset_ID]+"'",,acDialog

where Me.[Asset_ID] is the field name containing the Asset_ID in your form.

acDialog will open the form as PopUp

Hope this will help

Upvotes: 2

Related Questions