Selecting record in list box to open record in another form

[jobrien4]

I created a search form that searches for Customer Number, Part Number, and Revision Number. The results are displayed in a List Box.

I want the user to be able to make a selection on the List Box and click an "Open Selected" button that launches that record in another form. How is this possible?

 

[jobrien4]

This is what I'm trying right now:

Dim SelectedPartNumber As String
Dim SelectedRevisionNumber As String
Dim SelectedCustomerNumber As Integer

SelectedCustomerNumber = Me.SearchResults.Column(0)
SelectedPartNumber = Me.SearchResults.Column(1)
SelectedRevisionNumber = Me.SearchResults.Column(2)
DoCmd.OpenForm "frm_PartDatabase", acNormal, , "Forms![frm_PartDatabase]![PartNumber]=SelectedPartNumber AND Forms![frm_PartDatabase]![RevisionNumber]=SelectedRevisionNumber AND Forms![frm_PartDatabase]![CustomerNumber]=SelectedCustomerNumber"


When I debug, I'm getting the correct numbers as the variables, when it opens the new form, it's asking for the values as if it were a paramter query

 

[vbaInet]

You were almost there jobrien.

DoCmd.OpenForm "frm_PartDatabase", acNormal, , "[PartNumber] = '" & SelectedPartNumber & "' AND " & _
                                               "[RevisionNumber] = '" & SelectedRevisionNumber & "' AND " & _
                                               "[CustomerNumber] = " & SelectedCustomerNumber