Subform Sorting..Access 2003

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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]
 
John - that was it..when I changed the RecordSource to a Query, and then
Sorted..problem bye-bye.

Thank you - Bob
 
Back
Top