By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,914 Members | 1,100 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,914 IT Pros & Developers. It's quick & easy.

Tab past a field but still update it

P: 1

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.


Sep 12 '07 #1
Share this Question
Share on Google+
1 Reply

Expert 100+
P: 114
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.
Sep 12 '07 #2

Post your reply

Sign in to post your reply or Sign up for a free account.