I created a form using two tables, but when I access it in form view, I can't edit/add data. I have checked that it will allow edits/deletions/additions, nothing is locked and fields are enabled. The tables are linked by the column they have in common. I have searched for an answer for three days to no avail! Can anyone help?
RowanFV, welcome to the Forum.
It sounds like you have made what is known as a non-updatable Recordset. It is not normal practice to have 2 tables on one form, you would normally use a Main form for the main table and a Sub form for the secondary table.
But it does depend a little on how you have "Related" them in the Table Relationships.
Can you post a Screen Print of your relationship in an Office 2003 program format (word, excel etc)?
I checked the relationship, and sure enough, hadn't done it properly. Thanks for the pointer!
Cheers,
Rowan
Status
Not open for further replies.
You have insufficient privileges to reply here.
Related Threads
?
?
?
?
?
Tech Support Guy
9.9M posts
859.7K members
Since 1998
A forum community dedicated to tech experts and enthusiasts. Come join the discussion about articles, computer security, Mac, Microsoft, Linux, hardware, networking, gaming, reviews, accessories, and more!