Hello,
I am working on anothers database that has a couple of bugs in it. One of them in which I am trying to work out has a subform within a main form. When the form (that holds the subform as well) is loaded, the tab starts in the datasheet subform. When someone presses a button, access pops up and displays a msgbox saying that the "record is read only and cannot be set." I want to get rid of this problem and this darn message box because then, the form allows me to input information and a macro allows the update of the main table.
The subform gathers its information from a query which selects it off of a table...basically QuerySelectHours is the query which gathers information from the SHHR Table. When I open the query in datasheet form view, I am able to insert information into that datasheet, but for some reason, not on the subform.
I have looked at the AllowAdditions, AllowEdits, AllowDeletions, etc, DataEntry, and they are all set to Yes or True. I have tried various EventProcedures, but maybe Im coding wrong? Well, obviously I am, please help!!!!