Ask Your Question

Why am I unable to add a new record in my form?

asked 2016-01-27 11:51:05 +0100

threetoascreen gravatar image

I apologize, I'm new to this so if I miss something important please let me know.

I created my tables and my query, and I created a form from that query. However, when I open the form, most of the buttons on the bottom are grayed out. Except the movement buttons (next record, etc), Sort, Form-Based Filters, and Data Source as Tables. The text boxes are also grayed out, but still display information.

The form immediately opens one of the records that I made, all the information from the query, etc, but I'm unsure why I am unable to create a new record. In Control>Form Properties>Data I Allow additions, modification, deletions, and I do not allow Add data only. The Cycle is Default.

Thank you for your help.

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2016-01-27 23:19:54 +0100

jay Arr gravatar image

If your query and/or form does not include the key index field your table you won't be able to add records.

This might be the problem.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2016-01-27 11:51:05 +0100

Seen: 1,277 times

Last updated: Jan 27 '16