I created a form (via the wizard) that uses a query that pulls data from two tables (Staff and TimeSheets) interrelated by a StaffID field. I get an error when trying to add a new record to the TimeSheets table. The message states: The field TimeSheets.StaffID cannot contain a Null value because the required property for this field is set to True. I can see the value in the field for TimeSheets.StaffID and it isnt Null; all the data is clearly visible on the form. The StaffID used, is kept in a hidden field on another form thats open when this form displays the data.
What is wrong and what am I overlooking? Thank you.