Look at the form properties, make sure Allow Additions on the Data Tab is set to Yes.
Also, if your form record source is a query make the query is updatable.
If the latter is the problem, check this link: http://allenbrowne.com/ser-61.html
Look at the form properties, make sure Allow Additions on the Data Tab is set to Yes.
Also, if your form record source is a query make the query is updatable.
If the latter is the problem, check this link: http://allenbrowne.com/ser-61.html
The query you use as source for the form is non updatable.
Check the link in my first post and/or do a search on this forum on the subject.
There are a lot of posts handling this issue.
The query you use as source for the form is non updatable.
Check the link in my first post and/or do a search on this forum on the subject.
There are a lot of posts handling this issue.
What you are doing is combining fields of all tables in one form, you cannot add and update like that.
Look at using a main form for the main table and subforms for all others. You can still put subforms on tabs, so it will basically look the same. And of course you have to link main form and subforms appropriately.
Again do a search, this has been mentioned numerous times and Google for some sample databases. Studying those will help you tremendously.
That makes sense, the problem with subforms (apart from the 1st tab for comments which would benefit from a subform as that is continuous and therefore not restricted to 7 or 8 max) sub forms dont display is the same way as they are currently laid out,
So i guess my only other option is to have button to open forms to replace the other current tabs?
What is the best option as I am sure you can see from the attached database what I am trying to do