Can't assign value to this object (driving me mad)

[mrtn]

Hi

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)

 

[boblarson]

You can't have the main form bound to the same table as the Table 1 subform.

 

[mrtn]

Thanks for all your help.

I am designing a database which will hold quite a lot of client info relating to insurance policies, dates etc. I have created couple tables holding seperate lots of info grouped in various areas. What I am actually trying to achieve is to have one form with tabs which is controlled by record selectors. Because of this obstacle I have decided to link tabs with the ClientID field (because that was the only solution that I figured out).

The idea is for the default tab to show client name, address, contact details etc. 2nd tab would contain income details, 3rd tab would contain a subform with another lot of tabs with different types of products.

Unfortunately the solution provided by Uncle Gizmo would not suit my purpose in this instance because of the amount of data and the way it's supposed to be grouped.

I have attached my database which is still in development and hopefully will give you an idea of what I am trying to achieve. It's a combination of Polish and English but I am sure you'll have no problem in figuring it out. (Had to zip it because the file's too large (3.5mb))

Any ideas how to simplify it or a workaround relating to the error I am getting are welcome.