Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Set AllowAdditions Property in subform from Main form 1

Status
Not open for further replies.

vfisher

Programmer
Apr 15, 2002
40
US
I'm using Access 97 and depending on certain criteria, the properties of the subform (AllowAdditions, AllowEdits) need to be set from code in the main form.

I'm sure it's easy but I cannot seem to get the syntax correct. Here is the latest iteration:
Forms![frmBilling]![frmPremiumTransactions_subform].AllowAdditions = True

Please help. No matter what I do, I can't seem to get this set from the main from.

Thanks.
 
Are you using an IF statement depending on certain criteria or clicking a button to activate the code?
 
I'm using an IF statement to determine when to set the property.
 
Are you getting an error (if so what) or is it just not doing anything !
 
Thanks for the help. I finally found the correct syntax for this:

Forms![frmBilling]![frmPremiumTransactions_subform].Form.AllowAdditions = True

I just left out .FORM after the subform name.

Thanks Again.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top