Combo Box Look Up - Writing Values to a Table

[DJ100]

Hi,

I use a combo box on a form to select info and update text boxes on the form . . .

Ie Combo Box Shows 3 Fields - to enable selection, Once selected 10 Text Boxes are updated . . . .

As the text boxes are bound to the select query for the form (so that the data updates if a different selection is made) I am having difficulty writing the results to a different table from which they originate . . .

I need to do this so I can keep the integrity of 'Old' Data

Would appreciate some help

Ta

 

[dcx693]

You can use an append query if you want to write the data to a different table. You can also use DAO/ADO.