Value in field of sub form

  • Thread starter Thread starter ron bromwell
  • Start date Start date
R

ron bromwell

I have a button on a form. This form also has a sub form.
I want to set up code so that when the button on the form
is clicked, it will display a value of a text box in the
sub form. I plan to use a simple msgbox to display the
value. What I can't seem to figure out is how to
reference the value in the text box of the sub form. I
thought the following would work, but I get a "method or
data member not found" error when I open the form:

msgbox subfrom.textfield.value
 
Are you referencing the subform by it's control name? The
syntax should be
Me!subformcontrol.Form!textfield.Value

Hope This Helps
Gerald Stanley MCSD
 
Back
Top