I'm running VB5, and I've created a INPUT Box which searchs for a Customer Number (based on the customer name that the user inputs), and then launchs another form to display the name(s) on a DBGrid.

The search seems to work, but it never brings back all of the correct records. For example, when I type in "Smith" VB brings back 3 records when there are 94 Smiths in the database. I'm not sure how to fix this or why this is happening.

Additionally, the database that VB is accessing has three columns (the customer number, customer name, and customer status). I'm not sure how to make it so that VBGrid can display these three columns (as it seems to only be able to display two). In other words, what must I do to have VBGrid display the customer status along with the customer name and customer number?

Thanks for your help,
Brandr Beekman
[email protected]