No Updates once date is entered into text box

[TIDMAN]

Hi there all, I tried the search option on this board but maybe its just that i dont know how to ask the question.
I have a text box on my form with and afterupdate event that inputs todays date in to another text box on the same form, can this be set so that once that date is apperas in the text box that no further updates to the date can take place.

Thanks in advance for any help.

TIDMAN.....

 

[Bat17]

in the properties for the date control set Enabled = False this will stop anyone typing a date in there.
on the first text box check if the date field is Null before wrighting.

if isnull(me.MyDate) then
me.MyDate = now()
end if

HTH

Peter

 

[neileg]

If you only want the date and not the date and time use
me.MyDate = Date()

 

[TIDMAN]

Thnanks guys, i will give that a shot.

 

[TIDMAN]

on the first text box check if the date field is Null before wrighting.
I dont have a date field in the first text box?

where would i input this code?
if isnull(me.MyDate) then
me.MyDate = now()
end if

Thanks in advance for any help.

TIDMAN....

 

[Bat17]

MyDate is the field where you store the date. This code runs from the afterupdate event of the box they type in.
The isnull() checks to see if a date has already been added, if not then put in todays date, it it already has data then skip it.

Hope thats clearer.

Peter

Peter

 

[TIDMAN]

Thanks so very much bat17 works like a charm.

TIDMAN......