Subform won&#x27;t allow updates

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

>by checking the subform control's master/child links in the main form's design view?

Do this by selecting the subform in the mainform's design and looking in the properties window -> Data tab -> Master Links andChild Links

ASKER

mbizup, yes, I did check the master link and at first they were linked by ID, but then I took that out and verified it. (thanks for the clarification on how to do this).

Have you also made sure that the subform control (as seen in the main form's design) is enabled and not locked?

ASKER

enabled = yes
locked = no

baffling. thanks for the advice.

The form is a tabbed form with one subform.

SOLUTION

puppydogbuddy

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

ASKER

Still baffling . . .

I only want 1 record in the table, so in the subform

AllowEdits = Yes \
\
AllowAdditions = No / ---- works when running the subform by itself
/
AllowDeletions = No /

puppydogbuddy

when subform run by itself, it is unbound and has no link to main form.that is why it works.

I've been trying to recreate this problem on a test form... to no avail. By "unable to update" do you mean:

- Able to edit but unable to save
or
-Unable to edit at all
?

ASKER

thanks for trying.

the field is not editable, it's locked. I can click in it but can't change data.

SOLUTION

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

ASKER

Aha ! Good question

The main form has AllowEdits = No.

But in the Load event, if [such and such], I say AllowEdits = Yes.

So this works for the main form (allowing and not allowing edits), but saying AllowEdits in code doesn't translate to the subform.

In the properties of the main form I said "AllowEdits = Yes", now I can edit the subform !

So how do I get edits in the subform under this situation:

Start out mainform, allow_edits = No

In load event, if {true condition}, then allow_edits = yes
*** Now what to allow edits in the subform??? ***

In the subform, it's always allow edits = yes, set as a property.

ASKER

I can turn around my code to do it, will do so now.

ASKER

Ok, I reversed the code and allow edits to start, then turn off. It works great but my original dilemma wasn't solved, but it's not an issue now.

ASKER CERTIFIED SOLUTION

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

ASKER

Ok, I didn't think I'd have to do that. Also, with the Me.subform.form I don't think you get the "intelli-sense", so I try to avoid wrestling with subforms if I can. I use them a lot but it can be tricky. Thanks for your help.

Glad to help!

>Also, with the Me.subform.form I don't think you get the "intelli-sense"...
This is true. However, if you have a vague memory of what your subform control names are, go ahead and type them in lowercase. If you are on the mark, they will automatically be converted to the correct case when you move on to the next line of code. If they stay in lowercase, you know you need to refresh your memory fron the form's design ;-)

It's not quite intelli-sense, but it's the next best thing!