How can I go to another record in a form by using combo box

[kathat]

I have a form with a combo box that I want to use for navigating through the records. I have 10 records (for test purposes) in my table (mainly text boxes, but also a check box and an ole object for pictures). When navigating through the records by using page down or the default record navigator everything in the form change according to what I have entered into the table (Table_Person).

Instead I want to use a combo box to navigate the records. First names (Col_First_Name) are displayed in the combo box. I don't allow first name dublicates even though the primary key is the Col_ID.

So what I am trying to accomplish here is to go to the record associated with the first name that I choose in the combo box. Of course everything else in the form must change as well (txt boxes, check boxes, images etc.)

How can I achieve this?

[dima69]

I have a form with a combo box that I want to use for navigating through the records. I have 10 records (for test purposes) in my table (mainly text boxes, but also a check box and an ole object for pictures). When navigating through the records by using page down or the default record navigator everything in the form change according to what I have entered into the table (Table_Person).

Instead I want to use a combo box to navigate the records. First names (Col_First_Name) are displayed in the combo box. I don't allow first name dublicates even though the primary key is the Col_ID.

So what I am trying to accomplish here is to go to the record associated with the first name that I choose in the combo box. Of course everything else in the form must change as well (txt boxes, check boxes, images etc.)

How can I achieve this?

Something like this :

Private Sub MyCombo_AfterUpdate()
Dim rs As Recordset
If Me![Col_ID] <> Me![MyCombo] Then
    Set rs = Me.RecordsetClone
    rs.FindFirst "Col_ID = " & Me![MyCombo]
    If Not rs.NoMatch Then
        Me.Bookmark = rs.Bookmark
    End If
End If
End Sub

[missinglinq]

Or if VBA code seems intimidating to you, let Access do the work and simply use the combo box wizard. Place a combo box on the form, and when the wizard comes up select the third option "Find a record on my form based on the value I selected in my combo box."

Click Next, then under Available Fields select Col_First_Name