Combo Box on Form

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Access 2000: Kinda new so please forgive me if there's a simple solution to
this.

I have a combo box on a form being populated by a table. Here's the deal.
Recently there have been some records added to the table and some that were
to be disabled. I've added the new records and now I'm trying to figure out
how to disable the old ones so that they can't be selected. They can't be
deleted b/c they are needed to reference other records.

Any help will be greatly appreciated.
 
Hi.

Modify the combo box' RowSource property query statement by adding a WHERE
clause that distinguishes between the active and inactive records. For
example, if you added an Inactive Yes/No field to your table, change your
statement to:

Select <fieldlist> FROM <tablelist> WHERE YourTable.Inactive = False;

Hope that helps.
Sprinks
 
It worked. Thanks a lot!!

Sprinks said:
Hi.

Modify the combo box' RowSource property query statement by adding a WHERE
clause that distinguishes between the active and inactive records. For
example, if you added an Inactive Yes/No field to your table, change your
statement to:

Select <fieldlist> FROM <tablelist> WHERE YourTable.Inactive = False;

Hope that helps.
Sprinks
Click to expand...
 
Back
Top