allowadditions in subform

  • Thread starter Thread starter geebee
  • Start date Start date
G

geebee

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.
 
geebee said:
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.
Click to expand...


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
 
geebee said:
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.
Click to expand...


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
 
Have you tried specifying the subform .Form in your code?

Instead of
...sbfrm_template.AllowAdditions = True
Click to expand...

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
 
Back
Top