I'm sure this is easy but I can't figure it out!
I'm running a Listbox of records which display all record from a given company, this is on a seperate form from the actual infomation for each record.
I'm trying to open up the specific record that a user selects but I can't make it open the right record. So far the code looks like:
Private Sub UpdateClaimBtn_Click()
Dim stDocName As String
Dim stLinkCriteria As String
Dim SelectedRec As String
SelectedRec = List9.ItemData(List9.ListIndex + 1)
' use to work out the record ID of the users selection
stDocName = "Claim_Table"
DoCmd.OpenForm stDocName, acViewNormal
Ideally I would like to open the corrisponding "FaultID" record on the Claim_Table form.
Any ideas or advice would be wonderful!