I got asked to do a search form for an Access database and since I've never done one before, I want to know where to start. Okay, here's the deal:
There are a bunch of fields, project name, title, date, group, etc. and I need to make a form to take user input, filter them from the database, and put that data onto a report to view. What I'm really unsure is how to get user input into a query to look for this stuff. Up until now, all I've been doing is making generic queries and then linking them to buttons and such. So if you have any advice, tips, or ideas, please tell me. Any would be appreciated because chances are that I would think it's a great idea; I'll give you a star too.
There are a bunch of fields, project name, title, date, group, etc. and I need to make a form to take user input, filter them from the database, and put that data onto a report to view. What I'm really unsure is how to get user input into a query to look for this stuff. Up until now, all I've been doing is making generic queries and then linking them to buttons and such. So if you have any advice, tips, or ideas, please tell me. Any would be appreciated because chances are that I would think it's a great idea; I'll give you a star too.