saving records

[GirlBlonde]

Hi

i have created a form where i use a combo box to look up a name and then it populates other fields via the code [Forms]![FrmNewApplication]![CboRCN].[Column](1)

my issue is probably basic but i am stuck nevertheless. when i click on the save button any new fields populated by these automated fields do not save into the table. only fields with the record source from the table. how can i tell access that i want for eg firstname to be saved using the second colum in a combo box? save users entering excessive data?

any help thanks.

Energy & persistance conquer all things!

 

[KenReay]

Have you "bound" the relevant fields to the underlying table/recordset?

If not, you need to do that, or to preform the update by executing an update query in the onclick event of the save (see docmd.runsql, docmd.setwarnings, and UPDATE in help)

Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
UK