Hi,
My tblGrades has a field called InterDept. On the form, if the user check the box for "On Site" a "-1" will be on InterDept field and if the box is blank "0" will be on the field.
My problem is on how I can change the "1" and "0" on the form for InterDept field and be:
"On Site" if it is for "1"
"Off Site" if it is for "0"
Thanks,
netchie