Form to query?

A

_Adrian

I'd like to have a field on a form where a user can enter a value, and have
that value passed to the argument in a query... suggestions on how this is
done, or tutorial?
 
B

BobT

1. Place the field on the form (e.g. a text box, combo box, listbox, etc.).
2. Create a query against the table(s) in question with one field's
criteria equal to the value of the field you added to the form (e.g.
[Forms]![Form1]![Text0]).
3. Add a button to your form that runs your query.
 
T

test guy

Hmmm... well, I tried using [Forms]![City_search]![Text1] in the criteria
for the query, and that actually fails to return the results I need.. but
even still, I need to know how to bind it to the form, and whats more, to
tell the button on the form to run the query using that criteria and then
display the results.. I'm a total newbie to access, though can usually work
my way around most apps... any help is appreciated
 
Top