Query question about Comboboxes and columns

[BJF]

Hello,

Is it possible to reference columns of a combobox in a query on another form?

Thanks for any information,
BJF

 

[Gasman]

Well you can reference a form control in a query, so why not just try. Remember they start at 0

 

[The_Doc_Man]

The trick is to remember that TWO items are needed to reference a combo box column - the column and the row. IF you have a single-select combo, the selected row is defaulted. If it is a multi-select combo, then you need to iterate through the rows to check for the .Selected property, or use the .ListIndex to determine which row was selected for the single case. There is also the hidden collection .ItemsSelected for multi-select only.

ComboBox.ListIndex property (Access)

Office VBA reference topic

docs.microsoft.com

ComboBox.ItemsSelected property (Access)

Office VBA reference topic

docs.microsoft.com

 

[Gasman]

I was only considering a single select combo? Not seen multi select combos, but then I only have 2007

 

[CJ_London]

Think doc mean list box

to reference a combo column the syntax is

Forms!otherformname.Comboname.column(1)

to reference the 2nd column but not sure that will work in a query

Try using the expression builder

 

[isladogs]

Multiselect combos are only available when using multivalued fields...which of course should be avoided like the plague

 

[Pat Hartman]

Is it possible to reference columns of a combobox in a query on another form?

No. If I'm going to need to reference other columns in a query, I do one of two things,
1. copy them to hidden textboxes and reference those
2. Join the query for the form to the lookup (use a left join) and bind the lookup values to visible textboxes. Remember, if you do this, you should lock the control to prevent accidental editing and I also set the IsTabStop property to No so the user just tabs over the fields.

 

[The_Doc_Man]

To those who question multi-select combo boxes, please see:

ms access form: combobox to multiselect dropdown menu

I have an ms access db which was made a few years ago for my company. I am trying to change a form entry from a combobox to a multi-select combo box (Check box). Currently, only one value can be sa...

stackoverflow.com

Combo Box Multi Select Saving

Hi All Its been a while...however I dont often get stuck and usually can solve things myself. However this is a mystery to me. The machine shop has decided they want an Access database and have given me a base form etc they want to use. On one of the forms to achieve input checking etc I...

www.access-programmers.co.uk

 

[Gasman]

I was not questioning it Doc, just that I was not aware of them, and so my answer was just for a single select combo