Prev: Subform in continuous form
Next: Combo box to search on a field in the subform
From: pjscott on 9 Apr 2010 14:51
Thanks for the help. It's time for the weekend so I'll give these a try on
Monday.

Hope you have a good weekend,

Paul


"John W. Vinson" wrote:

> On Fri, 9 Apr 2010 08:49:01 -0700, pjscott <pjscott(a)discussions.microsoft.com>
> 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]
> .
>
First  |  Prev  | 
Pages: 1 2
Prev: Subform in continuous form
Next: Combo box to search on a field in the subform