Lock Autofill box after first use

[Hutch]

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?

[MMcCarthy]

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

[Denburt]

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.

[Hutch]

I had it in VBA coding so i moved it to the autofill, thanks