Subform Sorting..Access 2003

[Guest]

I have a "normal" Subform whose Recordsource is a Table.

Selecting a Field in the Subform and Sorting that Field causes the Display
to show
some multiple identical records...as long as the User doesn't do that,
everything
is OK.

Ideas?? TIA - Bob

 

[John W. Vinson]

I have a "normal" Subform whose Recordsource is a Table.

Selecting a Field in the Subform and Sorting that Field causes the Display
to show
some multiple identical records...as long as the User doesn't do that,
everything
is OK.

Ideas?? TIA - Bob

Base the Subform on a properly sorted query. I have no idea what's in your
table or how the form is structured, so I have no idea why you might be seeing
duplicates!

John W. Vinson [MVP]

 

[Guest]

John - that was it..when I changed the RecordSource to a Query, and then
Sorted..problem bye-bye.

Thank you - Bob