How do you edit data in a form that uses multiple tables?

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

Guest

I am working with a form that uses multiple tables as a reference. It is not
allowing any edits. I have checked to make sure that Locked property is set
to yes & Enabled property is set to No.
 
I'm confused--if a control's Locked property is set to Yes, or the Enabled
property is set to No, you will not be permitted to change the data in them.
They should be set to No and Yes, respectively to permit changes.

However, certain queries are not updatable in and of themselves for a
variety of reasons. You can search this forum and or Google for conditions
that can cause this. Open your form's query on its own, and see if you can
change a record. If you can, then you will have to check the form and
control properties to see what's preventing changes. See the form's
AllowEdits, AllowDeletions, and AllowAdditions properties, as well as the
Data properties of each control.

Hope that helps.
Sprinks
 
I wrote it incorrectly, the properties are set correctly to Locked Property
No, & Enabled to Yes. I have been working on this for the past couple of
days. It's been frustrating...
 
Back
Top