Limiting List from Table Field

  • Thread starter Thread starter Julie Nicole
  • Start date Start date
J

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
 
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
 
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
 
Back
Top