Pull Downs

C

Curtis Stevens

Ok, I deleted DISTINCT from combo1 afterupdate coding.

But it pulls up same record for both, which I click on both, always same
record, not the second one.
 
R

Ron2006

Are you sure that you don't have some code that is RE-Setting the
rowsource. Access does not normally reset rowsource, although it will
set the filter depending on how it is used.

And as to the find first in the form's data, If you have some other ID
or autonumber field that is unique for each record, I would make a
query dependent on that field for the form rather than a clone with a
find first. Besides find first will find "FIRST" and that is not
unique enough to get the second record.

Ron
 
Top