I have a form called JobtrackingHome with a subform called jobtrackingsubform. Within this jobtrackingsubform is another subform in a datasheet view to enter in dates and times for employees on specific jobs.
When I click "New job tracking" button which updates the jobtrackingsubform to a new record, I click on the company combo box and after I select a company or type a letter I get the error
"You cant assign a value to this object" ...blah blah with a few things do not apply to me.
I do not have a code on this at all. Everything is being done by a query (per form). After I get out of the error message it still works, however, its annoying as mess and I need to figure out how to make it stop.
Any suggestions?
Also, my companyID field is a foreign key field that you select from a combo box, the control source is set to CompanyID from the query being run on the form and the record source is just a selection from the customers table.
I have a table: Jobs (with a PK as JobID = autonumber), then a table called trackinghours (with a composite key as trackingID=autonumber & JobID=number) The number is a long interger. The relationship is set correctly with cascade update/delete checked.
Cannot think of anything else to check on
When I click "New job tracking" button which updates the jobtrackingsubform to a new record, I click on the company combo box and after I select a company or type a letter I get the error
"You cant assign a value to this object" ...blah blah with a few things do not apply to me.
I do not have a code on this at all. Everything is being done by a query (per form). After I get out of the error message it still works, however, its annoying as mess and I need to figure out how to make it stop.
Any suggestions?
Also, my companyID field is a foreign key field that you select from a combo box, the control source is set to CompanyID from the query being run on the form and the record source is just a selection from the customers table.
I have a table: Jobs (with a PK as JobID = autonumber), then a table called trackinghours (with a composite key as trackingID=autonumber & JobID=number) The number is a long interger. The relationship is set correctly with cascade update/delete checked.
Cannot think of anything else to check on