I have a form in which I would like a list box (or similar object) to be poplulated based on a letter entered in a text box. The user enters a letter in "txtFirstLetter" textbox. That letter should trigger a query that is something like ...
SELELCT CustCode FROM tblCustomer WHERE CustCode like "txtFirstLetter" *
I'm not sure how to properly write the code in vb, nor how to populate the list box (I'm assuming that is the proper object to use).
The purpose is for a user to see what CustCodes have already been used based on the letter they select in txtFirstLetter.
Thanks in advance
SELELCT CustCode FROM tblCustomer WHERE CustCode like "txtFirstLetter" *
I'm not sure how to properly write the code in vb, nor how to populate the list box (I'm assuming that is the proper object to use).
The purpose is for a user to see what CustCodes have already been used based on the letter they select in txtFirstLetter.
Thanks in advance