"Reading" user input

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
 
S

Steve Schapel

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]
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top