Find record using combobox in ADP form

[Guest]

I have a form in an ADP with a combobox that I created with the 3rd option in
the wizard. I put the combobox in the form header and have the detail section
invisible until an item is chosen in the combobox. The problem I'm having is
that the detail section always shows the first record in the recordset the
first time the combobox updates, but works fine and finds the correct record
every time after that. How do I get it to move to the correct record the
first time?

 

[Guest]

Never mind. I solved it by basing the form on a sorted view rather than on
the table itself and now it works fine.