M
Maria L
I am building a Vacation database for my group. Using a
form the associate is able to pick a vacation date
choosing to take a whole day (1) or a half a day (0.5). I
want to the user to be able to enter their name, date and
using a check box select a whole day or half a day. After
they click save the Days_Left value in the Associate2
table will reflect the total-[ASSOCIATE2]![T V/F/P DAYS]
minus the vacation day (either a 1 or a 0.5).
If Me![WHOLE DAY].Value = True Then
[ASSOCIATE2]![DAYS_LEFT] = [ASSOCIATE2]![T V/F/P
DAYS] - 1
End If
What is the best way to do this?
form the associate is able to pick a vacation date
choosing to take a whole day (1) or a half a day (0.5). I
want to the user to be able to enter their name, date and
using a check box select a whole day or half a day. After
they click save the Days_Left value in the Associate2
table will reflect the total-[ASSOCIATE2]![T V/F/P DAYS]
minus the vacation day (either a 1 or a 0.5).
If Me![WHOLE DAY].Value = True Then
[ASSOCIATE2]![DAYS_LEFT] = [ASSOCIATE2]![T V/F/P
DAYS] - 1
End If
What is the best way to do this?