Use Data From combobox for multiple queries

[WickidWe]

Overview

cboFunctions: combobox Using A Query (Returns:FctnID,FctnDesc,GroupID)
I have one query that Refers to Column 1(FctnID)


I need to be able to Refer to Column 3(GroupID) for another Query

How can I get the combobox info to work with both Queries?
Please include any VBA code if any is needed

thanks

[June7]

Reference combobox and listbox columns by index value. Index begins with 0 so column3 is index 2:

Forms!formname!comboboxname.Column(2)

[WickidWe]

I tried to put this in my query and came up with this error
undefined function 'Forms!Form1!cboFunction.Column' in expression

[June7]

Ooops! Now seem to remember reference to Column index does not work in query and testing gives me the same error.

However, textbox ControlSource can reference Column index:

= [cboFunction].[Column](2)

Then have query refer to the textbox instead.

I just don't use dynamic parameterized queries, I use VBA code to pass filter criteria to forms and reports.

[WickidWe]

Thanks Very Much, that worked
I would love to use more VBA, but one step at a time.
btw: how do I set this thread to "Solved"?

[June7]

Thread Tools dropdown above first post.