Value in field of sub form

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
 
G

Gerald Stanley

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

MS365 WORD: How to Create Macro Button to CLEAR ALL fields in fill-in form 1
Create form with checkbox les that expand and collapse sections of the form? 0
Clearing Fields in a Word Form 5
VBA - exporting serial letters to single documents 0
Testing for required data entry in form fields. 6
sync data on data field from key field in the sub form 0
Print A For (docm), Send Email Attachment And Close For Without Saving 2
I need to populate a sub-form field from the original form 1

Top