Two Lookup Combo Boxes on Same Form

[William Wisnieski]

Hello Everyone,

Access 2000

I've created a bound form to a table. I've added two lookup combo boxes so
the user has a choice of how to look up a record (Individuals or
Organizations). The first is based on [LastName]. The second is based on
the [Organization]. They are both simple combo boxes (I used the combo box
wizard) based on the underlying table. The first one works fine because
every record contains a [LastName]. However, the second one, based on
[Organization], contains blank lines in the comb box list because not every
record is an Organization.

How can I filter the second combo box so that only organizations without
blank lines are listed? I built a query that lists only Organizations
without blanks, but not sure how to tie it all together.

Any ideas on how to do this would be greatly appreciated.

Thanks,

William

[Rick Brandt]

William Wisnieski wrote:

Hello Everyone,

Access 2000

I've created a bound form to a table. I've added two lookup combo
boxes so the user has a choice of how to look up a record
(Individuals or Organizations). The first is based on [LastName].
The second is based on the [Organization]. They are both simple
combo boxes (I used the combo box wizard) based on the underlying
table. The first one works fine because every record contains a
[LastName]. However, the second one, based on [Organization],
contains blank lines in the comb box list because not every record is
an Organization.

How can I filter the second combo box so that only organizations
without blank lines are listed? I built a query that lists only
Organizations without blanks, but not sure how to tie it all together.

Use that query as the RowSource for the ComboBox.

--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com

[William Wisnieski]

Got it......thanks!
"Rick Brandt" <ri*********@hotmail.com> wrote in message
news:37*************@individual.net...

William Wisnieski wrote:

Hello Everyone,

Access 2000

I've created a bound form to a table. I've added two lookup combo
boxes so the user has a choice of how to look up a record
(Individuals or Organizations). The first is based on [LastName].
The second is based on the [Organization]. They are both simple
combo boxes (I used the combo box wizard) based on the underlying
table. The first one works fine because every record contains a
[LastName]. However, the second one, based on [Organization],
contains blank lines in the comb box list because not every record is
an Organization.

How can I filter the second combo box so that only organizations
without blank lines are listed? I built a query that lists only
Organizations without blanks, but not sure how to tie it all together.

Use that query as the RowSource for the ComboBox.

--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com