Pull Downs

G

Guest

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Pull Down Selection 2
Searching a Subform within a Main Form 2
Combine pull down + Vlookup return values in multiple cells 1
sql help 5
Lookup Wizard 5
Display Results from a select query in a subform 1
Updating a record 5
Populate combo box with record data when record is pulled by another combo box 3

Top