Update a form by a query...

[littlenicky]

I have a form, where I have a ComboBox(to choose a client), and the form should be an 'Update Clients' Details'. So I have there, also, Labels (which don't get changed) and TextBoxes which should be changed according to a query. In the query I put under ID criteria: [Forms]![ClientUpdate]![ClientsList]
(ClientsList is the ComboBox)
So how do I change the TextBoxes text according to the query?

 

[Jack Cowley]

Forms are 'windows' on your data. What you see in a form is the data from a table or the table via a query. If you want to change data in a table then you can use an Update Query to do that.

If what you want to do is show data on your form based on the selection you made in your combo box then remove the criteria from your query. Use the query OR the table as the Record Source for the form. On your form create a combo box using the Wizard and on the Wizards first screen select the 3rd item, "Find a record...". Finish the Wizard. Now selecting a client in the combo box will show their data in your form.

hth,
Jack