Re: Pull Downs

Okay, I think I understand now. What is your event code after a selection
is made in combo1? Are you setting the rowsource for combo2 and doing a
requery? Secondly, is the data in Combo2 from the same table as combo1?

Damon

"Curtis Stevens" <CurtisStevens@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:E59D352B-4EC9-4550-AC60-B0F47C44A892@xxxxxxxxxxxxxxxx
I have one master table that holds all records with relationalship tables
pointing to it, etc. They are two individual records. This merchant has
two
accounts or records as he has two businesses, two web sites he runs, dba
names are the domain names, but company names are the same for both. But
he
has an account for each and wont go into details as to why that must be.

However you want to think about it, they are SEPERATE records, just as if
it
was customer a and customer b with same business names by chance, as we
deal
with customers all over the US.

That's the problem, it isn't displaying both records, if they have the
same
name or same text info you are searching for, even though they are
SEPERATE
records in your table, but simply same company name.

Curtis


Okay, so CBox1 has two companies listed. If they are, in fact,
different,
then it should display two records. If they are the same, then your
table
is not set up correctly. There must be a reason to have two companies
with
the same name, otherwise, why do it? Sounds like you need to re-think
your
table structure and the relationships between your tables.

A combobox ONLY allows selection of one item. There is a multiselect
listbox object that may be what you are thinking of, but that will
require
some code to make it work properly.

Damon

"Curtis Stevens" <CurtisStevens@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in
message
news:47C2E111-D50E-4FD8-80E9-FA632C5A5975@xxxxxxxxxxxxxxxx
Here is an example: 1st combobox selects Company "A", 2nd combobox
uses
result of 1st ("A") and shows all company A contacts.
In second combobox, select one of the contacts. In the after update
event
display the results in the subform. It may be one or many records for
that
contact.... Are we on the same page?

This is how it works. However, the results in combo box #2, if there
are
two records with the same name, lets say a customer has two accounts
with
us,
same company name, different dba names. So when I choose company name,
there
are two records with ABC Flowers, but the combo box will only display
one
to
select, not both (abc flowers & abc flowers below it)

Curtis






.

Relevant Pages