another stupid question...i am having a bad day!!

jgoodman00 · Jan 24, 2001

Howdy,
I have a control on a form which is a calculated field. It combines two text fields to generate itself. How can I get this number into an underlying table automatically as soon as the field becomes valid (i.e. not null)???

Thanks

richardii · Jan 25, 2001

Create a field (concat) in your underlying table. Create an update Query:

UPDATE

SET

.Concat = [Forms]![Form1]![Text9]
WHERE (((Table.ID)=[Forms]![Form1]![ID]));

Text9 is you calculated field.

Run this query off the AfterUpdate events of the two fields you use to make Text9. Suppress the information messages about Updating. Adjust your tab order to make it happen The extent to which this is as 'instant' as you actually want, I'm not sure.

Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

another stupid question...i am having a bad day!!

jgoodman00

Programmer

richardii

Programmer

Similar threads

Part and Inventory Search

Sponsor