Access Date functions

I think there's like 3 ways of accomplishing this but...    I have a Text box on one of the forms that the user enters their Starting date of class.    I also have a combobox that keeps track of the status of the reservation.  (all be it manual)  Is there a way to tie the combo box and the text box together.    i want it to automatically change a "future" (combo choice)  reservation to "inhouse" (combo choice).  

SO.  I can get the combo box to change if the day is today but how do I write the  less than or equal to todays date?

If Text40 is < or = today then 
cboStatus ="Inhouse"

Open in new window

Who is Participating?
Jim HornConnect With a Mentor Microsoft SQL Server Developer, Architect, and AuthorCommented:
If IsDate(Me.Text40) then
   If Me.Text40 >= Date then
      Me.cboStatus = "Inhouse"
   end if
   'Me.Text40 is not a valid date.  Handle it here.
end if
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.