Selecting values from Combo boxes

  • Thread starter Thread starter Fie
  • Start date Start date
F

Fie

Hey,


Have a database and all the users are complaining abt how time
consuming Combo Boxes are. When they come to the combo box field for
selecting a site they want to type 1st letter of the site name and have
it come with the site, the only problem is that when they hit enter or
tab to move to the next field the value disapear from the combo box...
How do i get it to be selected without having to manually click on the
combo box and selecting the site from the list.


fie
 
Put this on the after update property and it will reduce the list to the 1st
parts of the text box. ie. Type the 1st letter of the item you want to find
or the 1st 2 letters, 3 letters, etc.

Private Sub Name of field_AfterUpdate()
Dim rs As Object

Set rs = Me.Recordset.Clone
rs.FindFirst "[name of list] = " & Str(Me![name of field])
Me.Bookmark = rs.Bookmark
End Sub


Hope this helps
 
iv tried this code but it comes up with an erro with

Private Sub Combo10_AfterUpdate() Highlighted

and also Me.Recordset.


any ideas me all confused
 
iv tried this code but it comes up with an erro with

Private Sub Combo10_AfterUpdate() Highlighted

and also Me.Recordset.


any ideas me all confused
 
Back
Top