Limiting List from Table Field

[Julie Nicole]

Hi,

I have used the lookup wizard in a form to select a field that is in another
table but I only want it showing up once, not mutiple times as in the table
otherwise its too long. I need multiple entries in the table but not to be
constantly repeated in a list box on another form. If its in the table 10
times it comes up in the list box ten times, I only want it once. Is there
a way to do this? Hope it makes sense!

thanks
Julie

 

[Nikos Yannacopoulos]

Julie,

Make a simple query on the original table, including only the target field,
and turn Totals on (View > Totals while in design view), leaving the Total
setting to the default Group By. Save the query. This query returns all
different entries found in this field, bu only once.
Now in your form design, use this query as the rowsource to your listbox (or
combo box), instead of the original table.

The same can be achieved by invoking the query builder directly from the
form's design, in which case you will not see the query in the database
window (it will be stored 'hidden' behind the form).

HTH,
Nikos

 

[Julie Nicole]

Hi Nikos,

WOW, That was so easy!
How do you know these things. They arent in the help files.
I do my best to try and figure something out but the help files are useless
and I seem to be ending up here more often than not.

Thank you so much for helping me with this query.
regards
Julie