checking enterred dates 1

[sblanche]

I have 2 tables. One my main (one) and the other a date table (many). On my data entry form I have a date tab. The date tab/table has"

In Date
Out Date
Date Item

My users are making data entry mistakes by enterring an out date (5/5/05) that comes before the in date (4/4/05). Is there a way to program the "Out Date" field in the form to check the "In Date" field to make sure the enterred date is "greater" > then the "In Date". If so, which "event" would I use (Lost Focus?). I would like them to get prompted that they have made a mistake before they can move away from the field.

thanks for your help.
SLB

 

[BoxHead]

On the AfterUpdate event of the Out Date textbox (assuming that txtIn and txtOut are the names of your textboxes - change as appropriate).

If txtOut < txtIn Then
txtOut=""
txtOut.Setfocus
msgBox "Hey, check your dates!"
End If

HTH

John


When Galileo theorized that Aristotle's view of the Universe contained errors, he was labeled a fool.
It wasn't until he proved it that he was called dangerous.

 

[sblanche]

John:
Works like a charm. Thanks very much!!

SLB