Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations dencom on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Referencing Field in Subform

Status
Not open for further replies.

ParyGoal

MIS
Jul 22, 2006
70
US
Hello everyone. I have multiple nested forms within an unbound main form. I have an unbound combo box from which user selects a name, and all the information associated with that name is displayed on all subforms. All I am trying to do is when I select a name from a combo box I want to capture the ID in display it in each subform. The value will be displayed in bound invisible text box. This methods works will only the first and second subform, which nested within a the first subform. I am not sure what I am doing wrong.
Here is the code i put in the default value of each text field:
=[Forms]![frmMTP]![cboMngTrainee] and I issue a me.refresh on the after update of the combo box.
Can anyone help me please?
Thank you
ParyGoal
 
how are ya ParyGoal . . .
ParyGoal said:
[blue] . . . all the information associated with that name is displayed on all subforms. . . .[/blue]
Why the redundency? . . . (I have to get past this first, as it appears on first look you have a Tables & Relatrionships problem!)

Calvin.gif
See Ya! . . . . . .
 
Hi TheAceMane1. I am doing good. How are ya?
I finally managed to solve the problem. I assign the value of each text box upon reading the value of the combo box. Using Form_Subfrom!ControlName. It's really wierd it worked on some subforms but not not others.
There is no redundency per say. I just have a complex database model. That's all.
Thank you
ParyGoal
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top