From: pjscott on
Thanks for the help. It's time for the weekend so I'll give these a try on

Hope you have a good weekend,


"John W. Vinson" wrote:

> On Fri, 9 Apr 2010 08:49:01 -0700, pjscott <pjscott(a)>
> wrote:
> >If there's 3 records with the same name the name displays 3 times in the
> >combo box.
> >
> >I need for the name to display single time then I can navigate through the
> >different records on the form.
> Use a different query than the form's recordsource as the rowsource; in
> particular, use a query which retrieves only one instance of each name. This
> could be based on the names table, or use a Unique Values query to display
> each name only once - not sure how your tables are structured so I can't say
> for sure!
> --
> John W. Vinson [MVP]
> .