Multiple Combo Boxes

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

My problem is that I need to create a form that will "read" user input into several combo boxes, and then use that information to display a set of records from a table. Essentially, this form will do the work of a query, but in a much more user-friendly fashion. I believe that this is probably not a very complicated procedure, but I have limited experience with Visual Basic for Applications and am having trouble getting started

Anything to get me off in the right direction is greatly appreciated. Thank you in advance

Jo
 
Joe
The easiest way to do this is to use a query-by- form approach. Create a query based on your table, and use the values of your combo boxes in the Criteria field ( use the expression builder to navigate to your form and simply pick the combo box that matches the field). If you have a command button on the form to view to data (after the selections were done), simply add some code to refresh the record source of the form (or you could use the After-update events of the combo boxes to give a "progressive" feel to the process)

Another option would be to filter the form based on the values of the combo boxes

Vlad
 
Back
Top