opening record based on listbox selection

[MinnKota]

On my Switchboard form (frmSwitchboard), I have a listbox (lstRecords) that has 5 columns that are filled by a query that basically shows record informations, one of which contains record numbers. When the user selects on of these records, I want to open a different form (frmCAREntry) but I want it to open to the record number that corresponds to what was selected on the Switchboard list box. What is the best way to do this?

 

[sxschech]

You can add this to the On Click event of the listbox:

DoCmd.OpenForm "frmCAREntry", acNormal, , "record_ID = '" & Me.lstRecords & "'"

You will need to change record_ID with the actual field name of the item you want selected.

 

[MinnKota]

I found this answer in another thread, except I had to remove both '

Thanks