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

re: Two Lookup Combo Boxes on Same Form

William Wisnieski wrote:[color=blue]
> 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.[/color]

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

re: Two Lookup Combo Boxes on Same Form

Got it......thanks!


"Rick Brandt" <rickbrandt2@hotmail.com> wrote in message
news:3719ldF58qdedU1@individual.net...[color=blue]
> William Wisnieski wrote:[color=green]
> > 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.[/color]
>
> 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
>
>[/color]