469,898 Members | 1,537 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,898 developers. It's quick & easy.

Fill recordset based on more than one combo box entry

I use combo boxes and a great little piece of code to fill a form with
a record set.
For example I want to search by Lastname and fill the form or by
company and fill the form, I will start typing the last name in a combo
and it fills ... press enter and the form fields load.

'Find the record that matches the pick.
Private Sub cbxLastName_AfterUpdate()
Dim rs As Object

Set rs = Me.Recordset.Clone
rs.FindFirst "[LastName] = '" & Me![cbxLastName] & "'"

If Not rs.EOF Then Me.Bookmark = rs.Bookmark

End Sub

My problem is, they want to be able to fill in the last name and the
first name because there are about 8,500 names in the database and the
last name will likely turn out to be someone else.

I have some ideas on this but nothing that feels real good to me.

Any suggestions?

Aug 18 '06 #1
0 1396

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

4 posts views Thread by Sherwood Botsford | last post: by
2 posts views Thread by Joanne Lewis | last post: by
8 posts views Thread by Geir Baardsen | last post: by
3 posts views Thread by Antoine Janssen | last post: by
1 post views Thread by omar.norton | last post: by
reply views Thread by Salome Sato | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.