I have created a database which is turning to quite a complex project (based on my Access skills).
I kind of know where the error is coming from but have no idea how to get rid of it...
I have tabs which contain subforms which are linked to a form containing tabs with ClientID. The idea is to navigate through all forms from the main form containing tabs. Whenever new data is entered into one of the fields I keep getting "You can't assign value to this object" error. The autonumber for the subform (frmTable1) is created but not for the main form (frmForm1). I can then enter the data (say record 3) which is then no longer visible when I go to record 4 and then back to record 3. When I close Form1 and reopen the record appears with no problems. It happens all over again on a new record entry.
It appears that the Form1's ClientID field is not refreshed automatically when the new ClientID is created in the subform.
I wonder if there is any workaround or did I completely get it wrong with designing the tabs?
I have replicated the error with a simple database created in MS Access 2010 (attached) cant-assign.accdb