cannot insert record

[Guest]

I have a database with two related tables and three forms. Each form shows
only relevant fields for the user's needs from the two tables. In one of the
forms, I cannot add a record. The option is "greyed out" in the drop down
from the toolbar, as well as "greyed out" in the bar at the bottom of the
only record that I currently have that is showing. I was able to add the
data from another form that is working for this database. The data source is
a query. The other forms tied to different queries are working fine.

I would appreciate any help in locating my problem. Thank you.

 

[Carl Rapson]

If you open the query directly, can you add records? If you can't, the query
is nonupdatable for some reason; you may need to rewrite it to be updatable.
If you can, check the AllowAdditions property of the form.

Carl Rapson

 

[Guest]

Thank you, Carl! AllowAdditions was "yes" on the form. So, I took your
suggestion and deleted the query and re-did it and . . . YEAH . . . this time
it works just fine! Thank you so much.