You cant go to the specific record.

[M.Qasim]

Hello,I am a newbie to MS Access, so please help me if someone can. I have three tables for which I created a form to fill in data. I inserted feilds from two tables, the add record button works fine but when I try to insert fields from third table it gives error. "You cant go to the specific record.". Now even if I remove the third table entry it still gives the error. Images are attached.

Button working fine with two tables fields inserted.

Added third table field.



Error.

Relationships of tables are one to one, (Enforce referential integrity and cascade delete records.)

[pbaldy]

Can you add/edit a record directly in the form's source query? I'm guessing it became read-only:

http://allenbrowne.com/ser-61.html

[M.Qasim]

Edition is possible. I couldn't add, Adding was not in the third table, it was giving error like there must an corresponding entry in other table (There was actually an entry in other tables). Anyway I changed the relationship, i.e. removed referential integrity and cascade delete. Then I was able to edit/Add. But the problem is still there, the add button is still giving error.

[ssanfu]

The relationships look suspect in the 3rd image. Why a 1-to-1 relationship? (very unusual)

You shouldn't be displaying the autonumber fields on a form.

See Microsoft Access Tables: Primary Key Tips and Techniques