Editing a value in a table

[SEAN]

Background info...
I have a combo box in my form that has all of our
customer account numbers in it. The value that is then
selected in the combo box will display the account name,
street address, city, st, and zip (These are all seperate
field names)

What I need to be able to do is first after I have
selected the account number in the combo box I then need
to have the option to be able to edit the address. This
will not always be needed but needs to be an option. I
get the following error message when i try to edit the
address.

"Control can not be edited; it's bound to the
expression '[Acct Name].[(Column](1)'

Can anyone help or have any suggestions?

Thanks,
Sean

 

[Allen Browne]

Set the Control Source of the text boxes to the name of the field where the
data should be stored, and use the AfterUpdate event procedure of the combo
to copy the value from the column to the text boxes.

For an example, open the Northwind sample database.
Open the Orders form.
Look at the AfterUpdate event procedure of the CustomerID combo.