Access 2003
I have a database with a table (tblCompanyInformation) which stores data that changes with each user. One of the fields in this table is WeeksforStudentCheckout. The PK is CompanyID. I have another table, tblStudentmaster, which contains the fields for a student order. It contains CompanyID as an FK. I use a query which links these tables, and serves as the basis for a student order form. One of the fields from tblCompanyInformation is WeeksForStudentCheckout.
The student order form contains a control called CheckOutDate, which defaults (correctly) to the current date. What I want to do is have another control, duedate, have a default value of CheckOutDate + ([WeeksForStudentCheckout] * 7). When I enter this as the default value in the form, and use the form to enter a new record, I get a blank in the field. What am I doing wrong?
Tia for all help.
| Reply via web post | Reply to sender | Reply to group | Start a New Topic | Messages in this topic (1) |
Tidak ada komentar:
Posting Komentar