hi,

i would like for the subform to be dynamically changed to where records can
be added when the main form is loaded... i now have:

Forms!frm_charity.Control!sbfrm_template.AllowAdditions = True


but i am getting an application-defined or object-defined error message.

not sure what to do.

thanks in advance,
geebee

It needs to be one of

Forms!frm_charity!sbfrm_template.Form.AllowAdditions = True

or

Forms!frm_charity.Controls("sbfrm_template").Form.AllowAdditions = True

Be careful, though, that you're referring to the subform control. Depending
on how you added the form as a subform, the name of the subform control may
not be the same as the name of the form being used as a subform.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)


"geebee" <(E-Mail Removed)(noSPAMs)> wrote in message
news:231F71B3-5AD7-4497-AA86-(E-Mail Removed)...
> hi,
>
> i would like for the subform to be dynamically changed to where records
> can
> be added when the main form is loaded... i now have:
>
> Forms!frm_charity.Control!sbfrm_template.AllowAdditions = True
>
>
> but i am getting an application-defined or object-defined error message.
>
> not sure what to do.
>
> thanks in advance,
> geebee
>

"geebee" <(E-Mail Removed)(noSPAMs)> wrote in message
news:231F71B3-5AD7-4497-AA86-(E-Mail Removed)...
> hi,
>
> i would like for the subform to be dynamically changed to where records
> can
> be added when the main form is loaded... i now have:
>
> Forms!frm_charity.Control!sbfrm_template.AllowAdditions = True
>
>
> but i am getting an application-defined or object-defined error message.
>
> not sure what to do.


Your syntax is wrong in two ways. First, it should be "Controls", not
"Control"; second, you need a ".Form" qualifier after "sbfrm_template".
You can leave out the ".Controls" qualifier entirely, though. Try this:

Forms!frm_charity!sbfrm_template.Form.AllowAdditions = True

--
Dirk Goldgar, MS Access MVP
www.datagnostics.com

(please reply to the newsgroup)

geebee <(E-Mail Removed)(noSPAMs)> wrote:

>i would like for the subform to be dynamically changed to where records can
>be added when the main form is loaded... i now have:
>
>Forms!frm_charity.Control!sbfrm_template.AllowAdditions = True
>
>but i am getting an application-defined or object-defined error message.


If sbfrm_template is the name of the subform **control** on
the main form, I think that should be:

Me!sbfrm_template.Form.AllowAdditions = True

--
Marsh
MVP [MS Access]

Have you tried specifying the subform .Form in your code?

Instead of
> ...sbfrm_template.AllowAdditions = True

try

....sbfrm_template.Form.AllowAdditions = True

--
Jack Leach
www.tristatemachine.com

- "A designer knows he has reached perfection not when there is nothing left
to add, but when there is nothing left to take away." - Antoine De Saint
Exupery


"geebee" wrote:

> hi,
>
> i would like for the subform to be dynamically changed to where records can
> be added when the main form is loaded... i now have:
>
> Forms!frm_charity.Control!sbfrm_template.AllowAdditions = True
>
>
> but i am getting an application-defined or object-defined error message.
>
> not sure what to do.
>
> thanks in advance,
> geebee
>