It does open at the first record in the form and at this point there are no records entered into the weekly stats. I entered a sample of data in closed the db and then opened the form and it did not give me the error. I then deleted the sample data from the weeklyStatSubFrm and when I open up...
One more thing!
I have my form completed but when I first open it up it gives me this error box
"The value you entered isn't valid for this field."
I have checked all of the fields and the settings are correct. when it opens it automatically fills in the first Employee from my Employee...
I created this form from the form Wizard. I open it up in design view and my fields are there and where they should be. I open up the form view and it is just a background with no Fields showing. It consists of a 2 tables and a Select Query. Any ideas?
I am creating a database with 3 tables
(*denotes Primary Key)
Employee Table
*Emp ID
FName
LName
CategoryTable
*Category ID
Category Name
Weekly Stats Table
*EMPID
*CategoryID
PrevReport
Received
Resolved
ONHand
Oldest Date On Hand
2ndary Claims
There are 5 different Category and each...