how can i code a search button to retreive all data by using client number or client surname

There are a few extra details that you have left out.

1) What kind of method are you using to store your data?
2) What kind of method are you using to display your data?
3) We need some code to help trouble shoot any problems that you may have.

If you can help us out, we may be able to help you out! :)

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.