Pulling up a record from a combo box

D

dave

I am trying to have it then when i select a record from
the combobox, it will go to that record, but for
somereason it is not working, here is the code:


Option Compare Database

Private Sub Combo39_AfterUpdate()
' Find the record that matches the control.
Dim rs As Object

Set rs = Me.Recordset.Clone
rs.FindFirst "[Phone Number] = '" & Me![Combo39] & "'"
Me.Bookmark = rs.Bookmark
End Sub
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Search combo box 2
Error 2147352567 2
Combo Box Error 3077 - Access 2003 1
Textbox Filter 4
RunTime Error 3070 11
Copy Record Button Function 1
Error 2237 8
Combo Box Updates, but Form/Data Doesn't 13

Top