Search results page

  • Thread starter Thread starter stema
  • Start date Start date
S

stema

Here is what I am trying to do.
I have a DB where I enter employee data into it. I want to be able to make
a search form where I enter the employees name the results will show in a
"log" type box that is no editable only viewable. It will show any
information related to that employee name such as date of injury, what type
ect. I've been going crazy trying to figure this out.
 
Put a combo box on your form using the wizard and select employee name for
the source. Right click on the combo, go to events, pick the afterupdate
event, click the little button to the right, and start the code builder. Type
Me.filter="[employee name] = """ & Me.combo# & """"
Me.filteron = true
The combo# will be listed, like combo8 or combo22
 
Back
Top