jakemdrew
asked on
Using Forms 2.0 Frame Control on MS Access Form
Please provide a VBA example of how to access and set the value of a textbox placed on an MS Forms 2.0 Frame Control within an MS Access form.
In Excel the following code displays the value of textbox1:
MsgBox Frame1.Controls("textbox1" ).Text
On an Access form, this does not work
In addition:
Frame1.Controls.Count = 0
In Excel the following code displays the value of textbox1:
MsgBox Frame1.Controls("textbox1"
On an Access form, this does not work
In addition:
Frame1.Controls.Count = 0
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Dim x As MSForms.Frame
Set x = Me.Frame4.Object
MsgBox x.Controls("textbox1").Val