Subform question

[Guest]

I have been trying to learn about subforms by looking at various examples.
Why is it that the fields in some subforms are editable (like the Orders
subform on the Orders form in the NorthWind sample db), while others are
not? In the db I'm working on, I can't edit fields in the subform, but I'd
like to. What am I missing?

 

[Mark A. Sam]

Is this a form that you created or someone's example? If this is an example
app, you can check these three things:

1) The subform control may have it's Locked property set to No. Click on
the control from the main form and open it's property sheet to check this.
2) The form which is the Object Source of the subform control may have it's
Allow Edits property set to No. You can address this by opening that form
from the database window or by clicking on it a couple times from the main
form, then looking at the property sheet. This may be confuisng to you, if
so I apoligize.
3) The textboxes (which you are trying to edit) Locked property may be set
to Yes.
4) The form's RecordSouce may be a query which is uneditable.

The properties may also have been set in programming to prevent editing.
This would be difficult to discover if you are inexperienced in Access.

God Bless,

Mark A. Sam

 

[Guest]

Thankyou Mark. It turns out your 4th suggestion is the one that applies to
me. Is there a way I can tell what makes a query's recordset editable or not?

Thanks
Sophie

Is this a form that you created or someone's example? If this is an example
app, you can check these three things:

1) The subform control may have it's Locked property set to No. Click on
the control from the main form and open it's property sheet to check this.
2) The form which is the Object Source of the subform control may have it's
Allow Edits property set to No. You can address this by opening that form
from the database window or by clicking on it a couple times from the main
form, then looking at the property sheet. This may be confuisng to you, if
so I apoligize.
3) The textboxes (which you are trying to edit) Locked property may be set
to Yes.
4) The form's RecordSouce may be a query which is uneditable.

The properties may also have been set in programming to prevent editing.
This would be difficult to discover if you are inexperienced in Access.

God Bless,

Mark A. Sam

 

[Marshall Barton]

I have been trying to learn about subforms by looking at various examples.
Why is it that the fields in some subforms are editable (like the Orders
subform on the Orders form in the NorthWind sample db), while others are
not? In the db I'm working on, I can't edit fields in the subform, but I'd
like to.

Is the form's record source query updatable?

Also check the form's AllowEdits property.

 

[Mark A. Sam]

Sofie,

Some possibilities:

1) It has a Select Distinct clause. This will be the first two words of the
SQL Statement.

2) It is a totals Query

3) It has a left or right outer join between tables.

These are usual causes. If you are linked to SQL Tables there are other
issues. Sometimes I need to play around a while to find the cause.

God Bless,

Mark

Thankyou Mark. It turns out your 4th suggestion is the one that applies to
me. Is there a way I can tell what makes a query's recordset editable or
not?

Thanks
Sophie

 

[Sirocco]

If you don't have design privileges, you won't be able to edit the data in
the subform, since the structure of the source query makes it uneditable -
complex queries tend to be uneditable by their very nature, not because the
designer intended the data to be uneditable. If you need to edit the data,
either make another form with a redesigned source query (one that's
editable), or ask the designer, if he's around, to do this for you.