Cannot pull values from Combo Box

[Robert Ross]

I've placed a combo box on my form that is driven from a
query. It contains two columns, UserID and Name. UserID
(column 1) is the bound column. Control Source is blank.
I have the Multi Select set to extended.

So I go and select 2 records from the combo box and try to
have another form display the value for that field -
nothing shows up. I then try to have a query pull up
records based on the two User ID's I selected in the combo
box, no dice.

Did I build the combo box wrong?

THX!

 

[Gary Miller]

Robert,

How can Access go to more than one record at the same time?
Have you checked the actual output of the ListBox (a
combobox does not have a MultiSelect property)?. It is
probably coming out like "36,43". When Access now looks for
a record it is looking for record "36,43" which of course
doesn't exist.

Also, if UserID is the first column, it is actually
column(0), not column(1).

You should consider just doing one record at a time or, if
you want to filter for a set of records, you will need to
parse the MultiSelect results.

Gary Miller
Sisters, OR

 

[Robert Ross]

The system is set up so that the list box initially shows
a list of employees assigned to the supervisor that signs
in to the database. The supervisor then chooses what
employees they want to report on from the list box, then I
need the query to pull records for each employee selected
in the list box.

I'm trying to check the outpot of the list box by having
another form post the value of that field, but it shows up
as blank.

As for the column numbers, I'm not sure what version
you're running, but my version of XP lists Bound Column: 1

Since I can't get a result from the field, I can't parse
the values.

Does this explain it more?