Remove a listing from the List Box dk

[Guest]

Hello All;

I have a list box on my form that has a prefilled list from another table,
and I have it coded so that this list autopopulates from this table. However,
there are two fields that I would not like to see on the dropdown list, and
was wondering on how to remove these two listings. One is the Primary Key
field, and the other is a join to another table. I have this pulling the data
using the properties box for the list box using the Row Source listing and
the Row Source Type as Field List, and the Control Source as the table name.

Any thoughts on how I can have these two fields not be visible on the drop
down lists?

Thanks.....

 

[John Vinson]

Any thoughts on how I can have these two fields not be visible on the drop
down lists?

Rather than setting the rowsource directly to the Table, set it to a
Query pulling the desired fields (and records) from the table. This
also has the advantage that you can sort the records in the
combo/listbox.

John W. Vinson[MVP]