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 SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Nested Subform Question

Status
Not open for further replies.

chew1920

Programmer
Jan 11, 2005
25
0
0
US
On my main form, I have a button that will lock and unlock the controls on the form. On one of my subforms I have a nested subform. I woul dlike to be able to turn off and on the AllowAdditions on the nested subform. I am able to do this on the subform, but not the nested subform.

Code:
Me.sfrmRevisions.Form.AllowAdditions = True
Forms!frmMain!sfrmRev!Form!sfrmReview.Form.AllowAdditions = True

The second line bombs when I am trying to access the subform. I also tried using
Code:
Me.sfrmRev!Form!sfrmReview.Form.AllowAdditions = True
but that bombed as well.


Thanks for the help

Matthew
 
Hi!

Try this:

Me.sfrmRev.Form!sfrmReview.Form.AllowAdditions = True

hth


Jeff Bridgham
Purdue University
Graduate School
Data Analyst
 
From the mainform:
Code:
[blue]Forms!frmMain!sfrmRev[red][b].[/b][/red]Form!sfrmReview.Form.AllowAdditions = True[/blue]

Calvin.gif
See Ya! . . . . . .
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top