G
Guest
What is the easiest way to create a GUI for users?
Basically, I just need something that will allow users to search a table
that has about 10 fields. Not all fields need to be filled in, of course.
Hypothetically, let's say the user wants to search on: Date, Name, ID, and
State. They'd key nothing in for date (they want all records), Smith, RRX,
and CA. Then, they click a button, and a query would be performed against
the table based on what they filled in each box.
Do I need to use VBA, or is there an easy way to use expression builder
inside the design view of a form to make this work?
Basically, I just need something that will allow users to search a table
that has about 10 fields. Not all fields need to be filled in, of course.
Hypothetically, let's say the user wants to search on: Date, Name, ID, and
State. They'd key nothing in for date (they want all records), Smith, RRX,
and CA. Then, they click a button, and a query would be performed against
the table based on what they filled in each box.
Do I need to use VBA, or is there an easy way to use expression builder
inside the design view of a form to make this work?