Conditions

N

NL

In a form, how do I create some conditions:
Fields are: user, date, time. User it's not available at a date or at a
time. How do I make that the field "DATE" don't accept a date or time for
tha user.
 
R

Rick B

Huh?

This question makes no sense. Give us a real example.

Waht is in the User field? What is in the date field? etc.
 
R

Rick B

By the way, the words "date" and "time" are reserved words and should not be
used as field names. This could cause all kinds of problems down the road.
You should use something like AddedDate or DateBegun or something.

Rick B
 
N

NL

The real field name is DateRvwd. If I enter today's date, but the user it's
not available today at 10 am, then not to accept the date and pop up an error
message. The user can be available at that date, but at another time. There
are about two tables, one with the users schedule and the other one to enter
the date to be scheduled.
 
D

Douglas J. Steele

In the text box's AfterUpdate event, do a lookup in your schedule table
whether or not the value is acceptable. If it's not, pop up a message to the
user, and change the control's value back to blank.
 
Top