RowSource with a twist 1

[MFFL]

not urgent, not important really, just curious.

i have no trouble referencing changing rowsource of combobox using:

.rowsource ="Select..."

However I would like to know if its possible to reference a query.

I figured [Forms]![membersModify] worked to access a form so I tried unsuccessfully:

.rowsource = [Queries]![qryName]

Purpose of this is i have an option group and depending on option i change combobox accordingly. I just figured each of the four queries were are defined and saved as reusable queries I might as well reference them through VBA. MMFL-
Mavericks Fan For Life

 

[jebry]

Hi MFFL!

As long as the rowsource type is Tables/Queries then you can put the name of a query in the rowsource and the combo box will work fine.

hth
Jeff Bridgham
bridgham@purdue.edu

 

[MFFL]

Jeff,

Thanks again. I thought I tried that first because it made the most sense.

Tried it again and worked great! MMFL-
Mavericks Fan For Life