Limiting List from Table Field


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
 
Ad

Advertisements

N

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
 
Ad

Advertisements

J

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top