"Reading" user input

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

Guest

I have posted something similar before, but have yet to receive a response, so I'll try to ask in a different way

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

Joe
 
Joe,

I think this is the essence of what you want. Display the results of
your selected data on a form. Have the recordsource of the form as a
query. In the Criteria of the relevant fields in the query, reference
the comboboxes where the user is entering their input, using syntax such
as...
[Forms]![NameOfUserInputForm]![NameOfCombobox]
 
Back
Top