Combo in subform

[kathy b]

I have a combo box in a subform of another subform. The linking field is
called IRB Number. The combo box row source is as follows:

SELECT [tbl Budget].[IRB Number], [tbl Budget].[Budget ID Item Number], [tbl
Budget].[Line Item Name] FROM [tbl Budget] WHERE ((([tbl Budget].[IRB
Number])=Me![IRB Number])) ORDER BY [tbl Budget].[Line Item Name];

The problem is that I have to enter the parameter of IRB Number to get my
combo box populate properly(filter for IRB Number). I have tried to fully
refer to the subform control rather than Me! but that did not work either.
If I enter the parameter when prompted the combo box does populate properly.

Main form is frmIRB
first subform is subfrmPatient
second suborm is subfrmPatientEvent

Any suggestions?
Thanks!

 

[Maurice]

I think you do have to fully qualify the position of the combo to get the
result like:

Forms![frmIRB]![subfrmPatient].Form![subfrmPatientEvent].Form![Combobox]

where combobox is the name of your combo on the second subform.

hth

 

[kathy b]

Perfect!! I had tried that myself, but was off slightly on the sytax.
Thank you!

I think you do have to fully qualify the position of the combo to get the
result like:

Forms![frmIRB]![subfrmPatient].Form![subfrmPatientEvent].Form![Combobox]

where combobox is the name of your combo on the second subform.

hth
--
Maurice Ausum

I have a combo box in a subform of another subform. The linking field is
called IRB Number. The combo box row source is as follows:

SELECT [tbl Budget].[IRB Number], [tbl Budget].[Budget ID Item Number], [tbl
Budget].[Line Item Name] FROM [tbl Budget] WHERE ((([tbl Budget].[IRB
Number])=Me![IRB Number])) ORDER BY [tbl Budget].[Line Item Name];

The problem is that I have to enter the parameter of IRB Number to get my
combo box populate properly(filter for IRB Number). I have tried to fully
refer to the subform control rather than Me! but that did not work either.
If I enter the parameter when prompted the combo box does populate properly.

Main form is frmIRB
first subform is subfrmPatient
second suborm is subfrmPatientEvent

Any suggestions?
Thanks!

 

[Maurice]

You're welcome ;-)
--
Maurice Ausum

Perfect!! I had tried that myself, but was off slightly on the sytax.
Thank you!

I think you do have to fully qualify the position of the combo to get the
result like:

Forms![frmIRB]![subfrmPatient].Form![subfrmPatientEvent].Form![Combobox]

where combobox is the name of your combo on the second subform.

hth
--
Maurice Ausum

I have a combo box in a subform of another subform. The linking field is
called IRB Number. The combo box row source is as follows:

SELECT [tbl Budget].[IRB Number], [tbl Budget].[Budget ID Item Number], [tbl
Budget].[Line Item Name] FROM [tbl Budget] WHERE ((([tbl Budget].[IRB
Number])=Me![IRB Number])) ORDER BY [tbl Budget].[Line Item Name];

The problem is that I have to enter the parameter of IRB Number to get my
combo box populate properly(filter for IRB Number). I have tried to fully
refer to the subform control rather than Me! but that did not work either.
If I enter the parameter when prompted the combo box does populate properly.

Main form is frmIRB
first subform is subfrmPatient
second suborm is subfrmPatientEvent

Any suggestions?
Thanks!