Combo Relating to Table

[JasGun]

I have a table with 4 fields. The first field contains text and the other 3 contain amounts.

I also have a form that is base on on the table above.
In the form I have a combo box relating to the text field.
And 3 text boxes relating to the amount fields.

What I would like is when I select the text field using the combo box, the amounts relating to that record are viewed in the three text boxes and I can change them and if they are changed then the value is stored in the table.

If anyone can help I would be grateful.

 

[AlexMidd]

The easiest way is to turn on wizards (make sure the little button with a wand on it is depressed on the tools toolbar). Then select the combo box tool and click the form to drop one onto it. The wizard should now start up.

When it asks what you want the combo box to do, select the last item in the list "Find a record on my form based on a value I selected in my combo box". Click Next, then select the field(s) that you want to be able to select (select the field(s) and click the '>' button. That is basically it apart from selecting the drop-down list width and the name for the control.

If you place your other controls to show the values in them you should now see these change as you select items in the list. Any changes should be stored as you type them for the selected record. Alex Middleton