Full Version: Combobox.column Method
UtterAccess Discussion Forums > Microsoft® Access > Access Queries
mjschukas
May 10 2012, 03:23 PM
can i use the ComboBox.Column method in a query criteria (parameter)...?
e.g., on a form, in a text box's control source: =[Combo1].[column](0)

???

thanks.
ScottGem
May 10 2012, 03:44 PM
I think you can use:

=Forms!formname!comboboxname.Column(x) in a query.

If not, set the controlsource of a text box to:

=Forms!formname!comboboxname.Column(x)

and reference the textbox.
mjschukas
May 10 2012, 05:10 PM
thank you...will do (text box works...)

thanks.
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here.