Getting data from empty queries want to bypass initial error messages

[pungentSapling]

This is a rather complicated thing to explain but I will try.
I have a database that has two main tables... one table is to hold data temporarily "untill it is doouble checked" the other table is for the "permanent storage of the data. I use an append query to move the data.
The form I use to input the data uses a query that gets the date from the last record created and puts it in the calander picker (ActiveXCtl)
The form also uses a query to get the employee Number from the last record created and puts it into the Employee Number combo box...these queries draw from the "temp table"
The idea being that the info from the last record will automatically be in place for the next record (The users have to fill in many occurances of the form that contain the same date and several in sequence that contain the same Date and same Employee Number.)
The problem occurs when the "temp Table" is empty. My queries come up empty and I get error messages about saving null values in required fields.
How can I get around these errors.
The form works but you have to click "end" in response to the run time errors.
I hope that this message is somewhat coherent. I barely am.

 

[boblarson]

What is happening is that in your table you have set up the fields to the default of Allow Zero Length is NO and if you want to quickly get rid of these errors, unless you have a pressing need as to why they can't contain null values, I'd just go into your table and in every TEXT field, change the ALLOW ZERO LENGTH property to YES.

BL
hth