How to Open Linked Form using Macro: MS Access

How to open Link Form using Macro

Picture below is a Customer datasheet form. We can assign a link to the Customer_ID field to open a Customer form by using Macro to link between the Customer_ID on both form.



Step 1 assign a field to click in order to open a link form

DSheet

Step 2 open a design view for your form. Select field you want to click and open a linked form then click on three (…) button under the On Click Event. In this example, I click the Customer_ID field

Onclick

Step 3 Select Macro Builder then click OK

selectMacro

Step 4  Set temp ID and open Customer form that has Customer_ID matching with Temp ID as shown in the Macro below:

assignMacro

Step 5   Select Customer_ID field under the form design view and change Is Hyperlink format to “Yes”

yesLink

Completed: on Datasheet form, the Customer_ID field will display as a linked field with blue color and underline on Customer ID. A Customer form with Customer_ID = 5 will open after a Customer_ID 5 on a Customer datasheet is clicked shown in picture below.

clicklink  linkdisplay