Search Box

  • Thread starter Thread starter Yecenia
  • Start date Start date
Y

Yecenia

I can't create a Search Box in any of my forms if my life depended on it.
Please help!

I have an employee DB and I have a table with all of their training. I need
to search all employees with a specific type of training. It seems too
simple, yet I can't do it. Help!
 
Put a combo box on your from. Allew the combo wizard to do that for you and
select your employees or employee ID as the source of the combo. Then right
click on your combo to get properties, go to the afterupdate property and
start the code builder. Type:
Me.filter = "[employee or emplyee id] = """ and me.combo# & """"
Me.filteron = true
The combo# will be listed, like combo10 or combo22
 
Thank you golfinray....I knew it was going to be something so easy... thanks
for the prompt reply!

golfinray said:
Put a combo box on your from. Allew the combo wizard to do that for you and
select your employees or employee ID as the source of the combo. Then right
click on your combo to get properties, go to the afterupdate property and
start the code builder. Type:
Me.filter = "[employee or emplyee id] = """ and me.combo# & """"
Me.filteron = true
The combo# will be listed, like combo10 or combo22
--
Milton Purdy
ACCESS
State of Arkansas


Yecenia said:
I can't create a Search Box in any of my forms if my life depended on it.
Please help!

I have an employee DB and I have a table with all of their training. I need
to search all employees with a specific type of training. It seems too
simple, yet I can't do it. Help!
Click to expand...
Click to expand...
 
Back
Top