Adding/editing records in a form

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

Guest

I am having trouble adding records (the new record icon is grey, won't allow
me to use it) and editing records (I can select text and fields, but cannot
alter it in any way).

I'm pretty sure my recordsource properties are correct and everything looks
fine, but this is happening in all of my forms. WHat would cause this and
how can I fix it?

Thank you for the help!

Matt
 
Open the form in design view, and look at these properties of the form:
Allow Edits Yes
Allow Additions Yes
Data Entry No
Recordset Type Dynaset

If they are all correct, but the form is based on a query, open the query
itself and see if the records can be edited there. If not, there is a list
of possible reasons here:
Why is my query read-only?
at:
http://allenbrowne.com/ser-61.html
 
Thank you for your help.

Data entry was set to YES, but I did have to change Recordset Type to
Dynaset (Inconsistent Updates). Works like a charm now.

Thank you for the other link as well.

Matt
 
Back
Top