How to pass 2 parameters from a list box into a query?

[superleochen]

When I choose an item with 2 columns in a list box, and press a button, I hope to pass this 2 columns as parameters into a query?

e.g.
WHERE (((Career_Profile.Job_Type)=Forms!Form_Development!Control_Job_Type) And ((Career_Profile.Job_Level)=Forms!Form_Development!Control_Job_Level)

The problem is that query only got the first column -"Control_Job_Type" and never got the second one - "Control_Job_Level".

What do you think?

[ChipR]

You need to reference the name of the combo box, then the appropriate column. The index starts at zero. For example:
Forms!myForm!cboDropDown.Column(0)
Forms!myForm!cboDropDown.Column(1)

[ajalwaysus]

I concur with ChipR. Even though you have multiple columns, when creating a combo box, you need to bound the combo box to a single value that you can quickly reference. ChipR's solution helps you access the combo box by each column.

Here s a quick look at bounding columns, FYI...
http://office.microsoft.com/en-us/ac...877861033.aspx

-AJ

[NeoPa]

Bound controls are certainly important. It is usual to bind a control to the underlying dataset in such cases. Only one column can be bound.

However, I doubt (not certain) that SQL can access the Column function reference required to access both columns. If it turns out that it cannot, then I suggest setting another control to reflect the value of the other column using an AfterUpdate event procedure. It would not generally be necessary to bind this other control (TextBox or Label would probably be the easiest to use).

[superleochen]

@NeoPa
You're so right. If I access the second column using Forms!myForm!cboDropDown.Column(1), it would only return the first row's second column, it doesn't reflect the value I choose from listbox.

And I use "afterupdate" to set another control to reflect the second column I "select", it works good!

Thank you guys!

[NeoPa]

I'm pleased to have helped.

Well done for taking that on and getting the solution to work for you btw.