Really easy question

[ZedtheHead]

I have a textbox on a form and what I want to do is have a user enter a value, click a button, and a query will run. The fields of the query will be used to fill out a number of other textboxes on the form.

I know this must be simple but I can't seem to get it. If I specify the query in a textbox's control source the text box shows #Name? , but it then can't be edited. What I want is a record to be retrieved, the values used to populate the form, the user can then make any changes he/she wishes, and then a button is clicked and the values used to replace the record that was retrieved.

I know a little SQL but I've never used access before and it's buzzing me. Access "help" doesn't. Please help!

There's got to be about a thousand tutorials out there on this...

 

[ColinEssex]

If you are just wanting to find a record based on a value you type in, you'd be better using a ComboBox with the wizard and select the 3rd option (find record based on ComboBox selection)


Col

 

[ZedtheHead]

I don't get a third option.

All the wizard gives me is a choice of how to get values to populate the combobox, that is,
a. look up the values in a table or query, or
b. type in the values that I want