Combo Box, sellecting only the record desired record

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have created a massive test data base, and want others to use it. I
created a combo box for them to pull up the record information by selecting
the test name in the combo box. The information pulls up in the form just
fine. But, If you use the thumb wheel on the mouse the information in the
form scrolls to the next set of data in the next record. What I want to do
is have only the data displayed for the test they originally picked from the
combobox. This could eliminate potential problems if they accidently hit the
thumb wheel and use the wrong data for testing.
Any suggestions?
 
Hi, JP.

Apply a filter to the form, using the combo box' value in its AfterUpdate
event:

Me.Filter = "YourField = " & Me!YourCombo
Me.FilterOn = True

Hope that helps.
Sprinks
 
Back
Top