Tab past a field but still update it

[Toolpusher]

Hi

I set the tab not to stop on a calculated control on a form but stop on the next data field where the user should enter the amount in the calculated field. Trouble I can only get the calculated control to update itself by stopping on it. If i set it to tab past to the next field it does not update itself until I save the record which is not use.

Even better if I could pick up the calculated fields value by tabbing past it that so when it stopped at the next field the value of the calculated field would show it that field and the user would just need to tab to enter it.

regards

TP

[damonreid]

Try the following on the field:

Enabled = False
Locked = True

This will stop anyone clicking on the field (or tabbing onto it) but still allow changes to it via VBA.