Search Box

[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!

 

[golfinray]

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

 

[Yecenia]

Thank you golfinray....I knew it was going to be something so easy... thanks
for the prompt reply!

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

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!