Update fields in table

[hologram]

A. We want to update a field in a table(1) with a value that has been set through a DLOOKUP from another table(2).
We have a combobox where we can select a conversion unit. With a DLOOKUP we lookup the conversion factor for this unit in another table(2) and put this factor on the form. We want this conversion factor to be updated in the table(1).

B. We also want to save calculated fields from the form in the table in the same way (without using an update query). We have many intermediate calculation fields that follow one another.

 

[KenReay]

Hi

You have a few choices:

Bind the table to the form

Have controls on the form to conatin the calculated values (hide them if you do not want user to see them)

do your calculation(s) in code and then set the value(s) into the control(s) and execute a DoCmd.RuNCommand acCmdSaveRecord to do the actual update

if you do not want to use that method

Open up the table as a recordset, and use the .edit .Update methods (not if youa re using ADO, .Edit is not needed

Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now -

http://www.kenneth.reay.btinternet.co.uk

UK