date from unbound textbox problem

[rob.low]

hi there

what i am having difficulty with is

i have a form with a unbound text box were a date is added by a user and
then a command button is clicked and if the date entered is say 10 days older than the todaysdate date it opens a different form
something like this??

date < me.textdate then
open form

any help will be appreciated

thanks
rob
sorry if it seems a bit vague

 

[ajetrumpet]

a command button is clicked and if the date entered is say 10 days older than the todaysdate date it opens a different form
something like this??

date < me.textdate then
open form

maybe this:

if dateadd("d", 10, me!textdate) < date() then
   open form

 

[rob.low]

thank you

maybe this:

if dateadd("d", 10, me!textdate) < date() then
   open form

thank you ajetrumpet

that worked like a charm
rob

 

[ajetrumpet]

sure thing. good luck.