cannot insert record

  • Thread starter Thread starter Guest
  • Start date Start date
G

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.
 
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
 
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.
 
Back
Top