469,317 Members | 2,039 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,317 developers. It's quick & easy.

Two Lookup Combo Boxes on Same Form

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
Nov 13 '05 #1
2 1592
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
Nov 13 '05 #2
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

Nov 13 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

3 posts views Thread by my-wings | last post: by
1 post views Thread by James | last post: by
9 posts views Thread by linda | last post: by
1 post views Thread by CARIGAR | last post: by
reply views Thread by zhoujie | last post: by
reply views Thread by harlem98 | last post: by
reply views Thread by harlem98 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.