really quick "subform ?" or, long "whats the best approach ?&quot 1

[LikeThisName]

short question?
is it not possible to get value from a textbox in a bound subform?

MsgBox Me!mySubForm.Question produces: run-time error 438

what I want to do is make me.Question = Me!mySubForm.Question
if me.Question fails to meet certain criteria

i thought using a subform that was bound and linked would be quicker then opening up tables, but maybe that was foolish.

What are your thoughts?

 

[LikeThisName]

i went ahead and opened a recordset and updated there then requeried

as far as my richtextbox subform i added that to main form but made invisible and used the open recordset to change the me.richtextbox1 then requeried the form and richtext subform. reason i have richtextbox in a subform in the first place was because of the editbar to format and load the text.

not urgent-
still interested in how to change or retrieve field values in subforms and your thoughts on approach. thanks!

 

[H82W8]

'Important: Differentiate between a form, a subform, and a subform control
'The first two are forms; the third is a control which is placed on a form and
'points to another form.
'frmSub is NOT necessarily the name of the source subform. Rather it is the name of
'the control I placed on my form. Click on the subform border to select it.
'The property sheet should start Subform/SubReport if it has Form instead, you
'miss targetted and chose the form to which the control points. You know you
'have it when the resize handles appear around the subform control.

'In my case, I made both my Subform/Subreport.Name ="frmSub" and
'Subform/Subreport.SourceObject = "frmSub" to avoid conflict. But just so you know,
'The code below requires "frmSub" to be the Subform/Subreport.Name

'Also note you can nest up to seven times using:
' Forms("frmMain&quot("frmSub&quot("frmSub2&quot("frmSub3&quot...("txtField&quot

Option Compare Database
Option Explicit
Private Sub cmdSet_Click()
'Using complete syntax to set a field on a sub form
'Forms("frmMain&quot.Controls("frmSub&quot.Form.Controls("txtLName&quot.Value = "YourName"

'Same thing but taking advantage of Access's default control properties
'Forms("frmMain&quot("frmSub&quot("txtLName&quot = "YourName"

'Same thing but but frmMain is current form so no need to reference
frmSub("txtLName&quot = "YourName"

End Sub
Private Sub cmdGet_Click()
Dim strLName As String
'Using complete syntax to get the value from a field on a subform
'strLName = Forms("frmMain&quot.Controls("frmSub&quot.Form.Controls("txtLName&quot.Value

'Same thing but taking advantage of Access's default control properties
'strLName = Forms("frmMain&quot("frmSub&quot("txtLName&quot

'Same thing but but frmMain is current form so no need to reference
strLName = frmSub("txtLName&quot

MsgBox strLName
End Sub

 

[LikeThisName]

Thankyou for posting. Very Helpful.