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

[jgoodman00]

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]

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.