Adding and Deleting records from forms

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

Guest

I have several forms connected to tables which I have been using for some time. I have been revising my forms during the past few weeks. However, somewhere I must have made a change that disabled adding and/or deleting records from some of the forms. Can you tell me where I could have possibly made this mistake?
 
Hi Len,

A couple of ideas come to mind. One is that the Allow Additions and/or
Allow Deletions properties of the form may have been altered. Another
possibility is that you have made changes to the queries that the forms
are based on, such that the queries are now non-updateable. Possibly
the easiest way to check this second option is to try to open the query
datasheet, and see if there's a blank row at the bottom.
 
Try switching the form to design view and then look at the propertie
for the form. There are specific options to prevent things lik
additions, deletions etc. I think there are similar properties for th
tables which the form is based on. If so, the underlying table may b
preventing the corrections. Hope this help
 
Try switching the form to design view and then look at the propertie
for the form. There are specific options to prevent things lik
additions, deletions etc. I think there are similar properties for th
tables which the form is based on. If so, the underlying table may b
preventing the corrections. Hope this help
 
Try switching the form to design view and then look at the propertie
for the form. There are specific options to prevent things lik
additions, deletions etc. I think there are similar properties for th
tables which the form is based on. If so, the underlying table may b
preventing the corrections. Hope this help
 
Thanks Steve,
I looked at the query in datasheet view and there is no
blank record at the end. How can I correct this
situation with the query?
 
Len,

There are a number of factors that determine whether a query is
updateable or not. There is a good Help topic on this in Access, if you
can find it. Some things which will make it non-updateable include the
use of domain functions, or cascading one-to-many joins. If you can't
work it out, post back with the SQL view of the query, and I'll see if I
can see the reason.
 
Back
Top