Combo Box Update

[gtcoglan]

Hi All,

I have a combo box on my form that is retrieving its list of values from a table. After I choose a value I want to write it to another table's field. I can get this to work where it is writing to the other table's field, but when I open the form to see the field of where the information is supposed to be writen to it is not refreshing. What property on the combo box should I used to ensure that the field of the other table is instaneously updated when the combo box's value is chosen.

Thanks
Greg

 

[Mile-O]

Why would you want to do this? Why is the form not bound to the destination table?

 

[gtcoglan]

The form is bound to the destination table. Maybe it is me pressing the button to many times?

 

[RV]

Why would you want to store the same data in multiple tables?
What you want doesn't make sense....

RV