Opening a form based on a record selected in a list box

So now that I have the list box working correctly I am needing the ability to select a record in the list box, double click it and a form displaying everything associated with the record is displayed.

I have a unique ID; Hardware_ID and the form I need it to open is frm_Inventory
The name of the list box is HWB_LIST

Thanks
John

DatabasesMicrosoft AccessVBA

Last Comment

John Sheehy

8/22/2022 - Mon

Fabrice Lambert

11/27/2017

Hi,

Use the double click event of your list box:

Private Sub HWB_LIST_DblClick(Cancel As Integer)
    Select Case HWB_LIST.Value
        '// ect ect ...
    End Select
End Sub

Open in new window

John Sheehy

11/27/2017

ASKER

I don't know how to tell the double click event to open the correct record. Maybe something like this?

stLinkCriteria = "[Hardware_ID]=" & "'" & Me.HWB_LIST.Hardware_ID & "'"
stDOCName = "frm_Inventory"

DoCmd.OpenForm stDOCName, , , stLinkCriteria

End If

John

ASKER CERTIFIED SOLUTION

John Sheehy

11/27/2017

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.

View this solution by signing up for a free trial.

Members can start a 7-Day free trial and enjoy unlimited access to the platform.

See Pricing Options

Start Free Trial

GET A PERSONALIZED SOLUTION

Ask your own question & get feedback from real experts

Find out why thousands trust the EE community with their toughest problems.

John Sheehy