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

Lock Autofill box after first use

P: 74
I have a problem, i created a "CALL LOG" for people at my office and i have a autofill box that fills in the time when they create the next "LOG" however if they go back to that log and click on that box or enter through it, it will again auto fill. I need to stop it from auto filling a second time. I have been trying to get it to work in VB but no worky, any thoughts?
Mar 16 '07 #1
Share this Question
Share on Google+
3 Replies


MMcCarthy
Expert Mod 10K+
P: 14,534
I have a problem, i created a "CALL LOG" for people at my office and i have a autofill box that fills in the time when they create the next "LOG" however if they go back to that log and click on that box or enter through it, it will again auto fill. I need to stop it from auto filling a second time. I have been trying to get it to work in VB but no worky, any thoughts?
If you used the fields default value to 'autofill' the textbox then it will only update when a new record is added. How have you set this?

Mary
Mar 16 '07 #2

Denburt
Expert 100+
P: 1,356
This can be done many ways What I would do is add code to the on current event for the form.


If not isnull(Me!myControl) and len(Me!myControl) >0 then
Me!mycontrol.enabled = false
else
Me!mycontrol.enabled = true
end if

Honestly though if it autofills you could just disable it hide it etc. and they could never touch it. Most of my applications I build has this to track the user entering data I use date and the UserName of whoever is logged in mine is usually hidden and if there are any questions about a record, viola I know who to hunt.
Mar 16 '07 #3

P: 74
I had it in VBA coding so i moved it to the autofill, thanks
Mar 21 '07 #4

Post your reply

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