By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,652 Members | 1,422 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,652 IT Pros & Developers. It's quick & easy.

Search Bar on a form

P: 1
Hey guys,

I'm making a standard hr database for my company. I'm having trouble creating a searchable bar on the form. What i want is to type a name or employee ID in a search bar on the form, and all the information on that employee will be filled in their respective field. I'm using MS Access 2013. Any help on this will be greatly appreciated!
Feb 10 '15 #1
Share this Question
Share on Google+
1 Reply


jforbes
Expert 100+
P: 1,107
NeoPa has collected a lot of information together on how to do this here: http://bytes.com/topic/access/insigh...filtering-form

The trick is to create a Where Clause based on what is entered in one or more TextBoxes and then set the Form's Filter to the Where Clause.

If you are still stuck after reading NeoPa's post, let us know what you are experiencing and we will help you out.
Feb 10 '15 #2

Post your reply

Sign in to post your reply or Sign up for a free account.