Can't add records using forms

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

Guest

I've recently designed a database with various related tables. The data is
created and updated using forms. For some reason, I am now unable to create a
new record in one of my forms. Any ideas?

Thanks

Dave
 
Having looked around the permissions for forms, I am unable to edit the data
entry/edit permissions. Since I'm the only one who has used the database, and
I hadn't got round to setting the security on it, I can't understand why this
would have happened.
 
Ok, from the beginning.

I created a database in Acces2000 format. I updated it to 2003 format with a
different filename. On the updated version, after deleting a record, I opened
the "Order" form and all the controls had disappeared. When switching to
Design View they were still there. Not a problem, the database had no real
data in it, and there had only been a few changes to the design, so I started
working from the old 2000 format version.

When this version was opened, new records could not be created in one
specific form, "Order". However, new records could be created in the data
table and displayed in the "Order" form. When going to Tools --> Security...
and viewing permissions for the offending form, permissions related to data
entry etc were greyed out. However, I don't believe this is the problem since
the same is true of all other forms.

Any ideas?

Dave
 
Sorry to be repetetive, but, /why/ could new records not be created in
the Order form? Was the "add new record" button disabled? Did you get
an error message?

Is the form based directly on the table, or on a query or SQL
statement? If the latter, what is the SQL of the query or SQL
statement?

Is the AllowAdditioons property of the form, set True?

HTH,
TC
 
The "add new record button" is disabled in both the navigation controls and
the menus. There is no error message.

The form is based directly on the table with a subform based on another
table included. The AllowAdditions property of the form is set to true.
 
So you can add new recrs to the table; the form is based directly on
the table; the form's AllowAdditions property is set to Tru; but you cn
not ad new records though th form?

That seems strange to me. Here's what I'd do.

On a /copy/ of the form:
- delete the form code module & see if that fixes it;
- if not, delete the subform ()from the subform control) & se if that
fixes it.

The intention above, is to try & narrow down the source of the problem.
If deleting the form's code module fixed the prioblem, you know the
problem is somewhere in that code module. Similarly if deleting the
subform fixes it. Of cours you would do all this on a /copy/ of the
form - not he actual form itself.

HTH,
TC
 
The form doesn't have any code. Deleting the subform didn't help either. I've
looked through every control to mkae sure data entry is allowed in each. I'm
not sure what to check next. Of course, I could rebuild the form but I'd
rather find the problem.

Thanks

Dave
 
Found the problem. I have a textbox containing a field from a query I use to
calculate a total, when this is removed I can add records again. Any ideas
why this would happend and how it can be rectified/
 
What do you mean, a textbox "containing a field from a query"? What is
the ControlSource of the textbox? How does the query come into it?

TC
 
Back
Top