Auto populating text boxes on an Access 2003 form when value selected in combo box

Question

Hello

I am building a form in access database.

I have a combo box which is linked to a query which is looking up a unique reference number from a table called Tbl_Submitted_Requests.

What I need the form to do is auto populate the other text boxes when the user selects the unique reference from the combo box. How can I get the text boxes to auto populate with the data that is associated with each unique reference?

Thanks

Answer 1

First, bind your form to Tbl_Submitted_Requests or better, a query that uses this table, you can do this with the form wizard or by setting the Record Source property of the form. Each of the textboxes will also need to have a control source set to the name of a field (column) Next, add a combo and choose "Find a record on my form based on the value I select in my combobox" from the wizard options.

Answer 2

I will agree with Remou's response, with one small edification. Crate a new form, and drag all of the fields from the relevant query or table onto this form. Alternatively, you can drag them from the field chooser if the form has already been bound. Then, create your combo-box, and choose "Find a record on my form based on the value I select in my combobox" from the wizard options.