How to generate the a form with a record selected from a list box

[lbradbury11]

I have a list box on the form that lists the all the records, I'd like users to be able to click on the record in the list box. After update it will populate the form with the record that was selected. What do I need to put in for the After Update, I used the macro builder to search for a record, but that is where I stall.

[moke123]

try the find first method.

something like:

   Dim rs As DAO.Recordset
    Set rs = Me.Recordset


    With rs
    
        .FindFirst "SomeField = " & Somefield


        If Not rs.NoMatch Then
            Me.Bookmark = .Bookmark
        Else
            MsgBox "Not Found"
        End If
        
    End With

[Bob Fitz]

I have a list box on the form that lists the all the records, I'd like users to be able to click on the record in the list box. After update it will populate the form with the record that was selected. What do I need to put in for the After Update, I used the macro builder to search for a record, but that is where I stall.

if the form is bound to a table/query then you could use the wizard to create a combo box control in the Header section of the form which would find the required record after being selected.