change the "Row source" of a combo box

[bnath001]

HI,

In the detail section of my form, and I have a subform in that detail section. I have a combo box in the subform and I would like to change the control source/row source properties dynamically.

How can I access those properties of the combo box which is in the subform.

could someone give some suggestion?

thanks
bvyas

 

[Lightning]

In whichever event you have chosen to change the RowSource, use this syntax (assuming this is being done from your MAIN form)

Forms![YourMainForm]![YourSubFormName!Form].SetFocus
Forms![YourMainForm]![YourSubFormName!Form].[YourComboBox].RowSource = "YourSQLString"

Have a look at the Access Helpfile topic Call Procedures in a Subform or Subreport for an explanation of this syntax.

HTH

Lightning

 

[bnath001]

thanks. But it doesn't work.

frmTabCustomers is the Main form.
subItems is the name of the sub form.
cboNames is the combo box which is on the sub form (subItems)

Forms![frmTabCustomers]![subItems!Form].SetFocus
Forms![frmTabCustomers]![subItems!Form].[cboNames].RowSource = "tbl_Screens"

It says "Microsoft access doesn't find the field 'subItems!Form' referred to in your expression.

can you suggest if I am doing any mistake?

thank you

 

[Lightning]

Oops! Sorry, my typing fingers aren't awake yet!!
Close the brackets after your Subform Name:

Forms![frmTabCustomers]![subItems].Form.SetFocus
Forms![frmTabCustomers]![subItems].Form.[cboNames].RowSource = "tbl_Screens"


"Sorry about that, Chief!"

Lightning

 

[bnath001]

Lightning,
I appreciate for taking time in responding my question. But it still says "There is an invalid method in an expression"
when it runs
Forms![frmTabCustomers]![subItems].Form.SetFocus statement.

May be I should let you know exactly what I am trying to do.
1. I have a Main form and in the details section I have a tab control.
2. On that tab control I have put a subform. which has a combo box control.
3. when the user clicks on different tab, I am trying to change the rowsource of the combo box which is in a subform.

I don't know how to change the rowsource in the subform.

thanks
nath

 

[Lightning]

OK - The tab Control changes things slightly, because you need to set the focus to the appropriate Tab page first.

Forms![frmTabCustomers]![TabPageName].SetFocus
Forms![frmTabCustomers]![subItems].Form.SetFocus
Forms![frmTabCustomers]![subItems].Form.[cboNames].RowSource = "tbl_Screens"

We'll get this working yet.

Hang in there!

Lightning