Pull Value From SubForm TextBox

[crhodus]

Hi Everyone,

Can someone point me in the right direction with my form?

Here is how my form is designed:

• Form BusinessForm has 4 tabs on it.

• Above the set of tabs is a TextBox named txtPulledName.

• Tab_1, on the BusinessInfo, form has a subform on it named subRMTDetails.

• The sub-form, subRMTDetails, points to an existing form named RMTDetails.

• RMTDetails has a TextBox named txtBusinessName.

What I want to do is have the value from RMTDetails.txtBusinessName show up in the BusinessForm.txtPulledName textbox. How can I do this?

In the past, I've used something like this in a TextBox to pass a value from one form to another.

= Forms!YourFormName!YourControl

If this will work, what would the syntax be?

Thanks,
crhodus

 

[rainman89]

see if this gets you going in the right direction
http://www.mvps.org/access/forms/frm0031.htm

 

[crhodus]

I've tried using the following in txtPulledName, but it still dispalys #Name? :
=[Me]![Tab_1]![SubRmtDetails]![txtBusinessName]
=[Me]![SubRmtDetails]![txtBusinessName]

 

[rainman89]

You wouldnt use me. You would use soemthing like

=Forms!RMTDetails!txtBusinessName

RMTDetails is not a subform on another form is it?

 

[crhodus]

Thanks rainman89. That helped me solve my problem. I had to use the following:

=Forms![RMTDetails]![subRMTDetails]![txtBusinessName]

crhodus