Help with a call to a subform textbox

H

hoffmantime

From the parent form(f_CofC), need to get the value of a
textbox(qty1) in the subform (Sub_data) and check to see
if there is a value in the text box. I was trying to use
the following command, but I kept getting something
similar to "the field (sub_data)could not be found"
Sub_data is my subform.
Here is the code I am trying.
If Forms!f_cofc![sub_data].qty1.Text > 0 Then

Any help?

Thanks,
 
S

Steve Conway

Hi Hoffmantime,

If Forms!f_cofc!sub_data!qty1 > 0 Then

Make sure *sub_data* is the name of the subform control on the mainform

HTH
Steve C
 
H

hoffmantime

-----Original Message-----
Hi Hoffmantime,

If Forms!f_cofc!sub_data!qty1 > 0 Then

Make sure *sub_data* is the name of the subform control on the mainform

HTH
Steve C

From the parent form(f_CofC), need to get the value of a
textbox(qty1) in the subform (Sub_data) and check to see
if there is a value in the text box. I was trying to use
the following command, but I kept getting something
similar to "the field (sub_data)could not be found"
Sub_data is my subform.
Here is the code I am trying.
If Forms!f_cofc![sub_data].qty1.Text > 0 Then

Any help?

Thanks,


.
Thank you for your help.
 

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

Top