I have a form that allows a user to search by any field in the database table. The PK is an ID number, and I have a DataCombo that lists all ID numbers in table so the user can easily select one. It's bound to an ADODC. Textboxes are used to allow the user to search by other field (such as name). When the form loads, I use the ADODC to select all the records in the table to populate the DataCombo box. After the user searches, all controls are then bound to the ADODC to display the records.
The error I get is this: Say the existing ID numbers are 111, 222, and 333. The user selects 222. Then the user clicks on one of the textboxes, and without typing anything, goes back and clicks on the DataCombo drop-down arrow. Now the list displays 222, 222, and 333! The only event I've defined that would occur during that time is mouse_move, and all it does is display help in the status bar (instead of using annoying tool tips). I haven't defined any other events that would occur, such as change or lost focus. Any suggestions????
An alternate solution would be to tell me how to automatically call my search function when the user selects an item in the DataCombo -- after all, if they know the ID, they don't need to search by any other criteria and I could automatically display record as soon as they select the ID.
Thanks!!!
The error I get is this: Say the existing ID numbers are 111, 222, and 333. The user selects 222. Then the user clicks on one of the textboxes, and without typing anything, goes back and clicks on the DataCombo drop-down arrow. Now the list displays 222, 222, and 333! The only event I've defined that would occur during that time is mouse_move, and all it does is display help in the status bar (instead of using annoying tool tips). I haven't defined any other events that would occur, such as change or lost focus. Any suggestions????
An alternate solution would be to tell me how to automatically call my search function when the user selects an item in the DataCombo -- after all, if they know the ID, they don't need to search by any other criteria and I could automatically display record as soon as they select the ID.
Thanks!!!
