Combo in subform

  • Thread starter Thread starter kathy b
  • Start date Start date
K

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!
 
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
 
Perfect!! I had tried that myself, but was off slightly on the sytax.
Thank you!

Maurice said:
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


kathy b said:
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!
Click to expand...
Click to expand...
 
You're welcome ;-)
--
Maurice Ausum


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

Maurice said:
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


kathy b said:
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!
Click to expand...
Click to expand...
Click to expand...
 
Back
Top