I have built an access db and I have a form with a list box on it that lists all my customers.
Cust Id, Last Name, First Name etc
I can scroll down the list and when I double click on the particular customer it will open up another form with their details on it which is what I want.
As I have so many customer records what I'd like to have is a text box at the top of the form that will filter the list by surname, ie if i type 'Jones' only the customers with that surname appear in my list box. I can then double click the record to view their details like I'm already doing.
Anyone got any ideas?
Thanks
Cust Id, Last Name, First Name etc
I can scroll down the list and when I double click on the particular customer it will open up another form with their details on it which is what I want.
As I have so many customer records what I'd like to have is a text box at the top of the form that will filter the list by surname, ie if i type 'Jones' only the customers with that surname appear in my list box. I can then double click the record to view their details like I'm already doing.
Anyone got any ideas?
Thanks