list box showing just number fields?

P

pinedrops89

Hello,
I have a list box on a form that currently shows the fields in a table
using Row Source Type set to Field List. There are many fields in the
table, and I would like the list box to show only those fields that
have a Number Data Type (to eliminate all the Text fields and make it
easier to see just the Number fields). The name of the table remains
the same, but the field names in the table can change. Is there a way
to do this?
Thanks.
 
P

pinedrops89

I think I figured out a solution. I created a query using VB that
contains just the Number fields from a table, and then used the query
as the Row Source, instead of using the table.
 
Top