Subform Sorting..Access 2003

B

Bob Barnes

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
 
J

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
Click to expand...

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]
 
B

Bob Barnes

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

Thank you - Bob
 
Top