Hello, How can I put a search box field on a switchboard that will look up fields in 4 different tables? Please submit answers with extreme easy step by step guidelines as I am a newbie to Access 2003!
Thanks
Aaron
by 
Aaron
ANSWERS: 2
-
A switchboard is intended to be the front end of your application, so that all the nasty tables and queries, etc are kept out of the sight of your users, so I don't think putting search boxes onto it is a very good idea. I would suggest that you have a form that you can open from the switchboard. Use a wizard to make the form and put each of the four tables into the form and it will almost certainly organise itself as a form with subforms, so you could then put the relevant search button or combo box into each section of the form.
-
Ok. Thank you for that.
RELATED QUESTIONS
Copyright 2023, Wired Ivy, LLC