I have a form that has a textbox used to search records in a table. On
the form I have a listbox which shows each record in the table. When
you click on each row in the listbox the rest of the form updates to
show the other fields in the table.
The problem I am having is when I enter text to search the table the
list narrows successfully, but the rest of the information still
reflects the first record in the table. When I click on one of the rows
in the listbox the rest of the form shows the correct information, but
I would like to have the form update when the selections in the listbox
are narrowed.
For example the listbox shows Row1 and Row2. Row 1 is the current
record in the table and the entire form shows that record. I type
"Row2" in the search box and click a command button that requeries the
listbox. The listbox now only shows Row2, but the rest of the form
still shows data for Row1. When I click on Row2 in the list (this is
the only choice) the form updates and shows the data for Row2. I can't
seem to be able to get the form to update so the first row is selected
and the rest of the form reflects the change.