Date validation

[anto.danny]

Hello,

I want a vba code that checks the date and if the date is below 1-1-1990 then it should open a form. I know a bit of vba but I cant figure out how to enter the date in vba

If me.dateofbirth < 1-1-1990 then
DoCmd.OpenForm "helloworld"
end if

Also which event should I put the code in, so that the form opens as soon as the user goes to the next textbox?

 

[arnelgp]

after update event of your control.

 

[anto.danny]

after update event of your control.

Its on the lost focus event of the dateofbirth textbox, but the code doesn't work when I enter a date below the year 1990. Is there a format I need to follow to use a specific date???

 

[arnelgp]

try casting your date constant with #:

If me.dateofbirth < #1-1-1990# then
DoCmd.OpenForm "helloworld"
end if

 

[anto.danny]

that did the trick...Cheers mate!!!

 

[arnelgp]

happy coding!