Retrieving multiple records to create history of client using VB

Dear forum members. This is my first time using such a forum so please be patient with me.
I would like to create a database which can enter data, retrieve data and edit data, and display multiple data entries of the same client pulling in all the relevant data.
I have created in the past VB forms and entered data, retrieved single line data entries and edited with success. My problem is to retrieve all the data from a single client, from an extensive list of clients, display the selected cells from predefined columns. I have used VLook up and match together, usually as excel coding not VBA. All the above was by studing VB examples and ploding through them.

There is currently no unique identifier with each client (although if required, this could be easily be done by concatenating say date of birth figures and say three letters of their surname with the initial of their forename for example).
There is date of entry against each client, (and also shown as a period within the financial calendar and year), forename, surname, data of birth, type of care packages etc.

My ideal solution is to enter data in a VB form it will search the relevant columns of data, with the user adding more data to refine the search in the following order:

Surname
Forename
Date of Birth
Other – subject to feed back

Then display all of the records against that client.

Best Regards Emanon57

Originally Posted by JBeaucaire

Sounds like a lot of work to duplicate Excel's built-in Autofilter (Table) functions.

Turn on the Data > Filter > Autofilter for that database, them just use the drop-downs at the to filter the DB any way you wish. You will be left viewing only the rows for those filters, edit as you see fit, then use new filters for new data, all from the main DB page. No VB, no forms, no maintenance.

Thank you for your comments and they would apply if I was managing the database. However, it has to be used by administrators who will not habe the same level of skill. In addition I have attached a financial package to calculate cost when ever the care package was introduced or ended. This info wil be required on another micro button. Hence the reason to do a lot of work to create a seamless presentation to the user.

Many Thanks

emanon57

Originally Posted by JBeaucaire

Well, I don't believe you would be asking us to design a whole form-based user interface, for you, right? So, your specific question for us would be...?

We expect you will design your form and do the work to layout it out (learn as you go, that's how we all do it), and posit us queries when you get stuck along the way.

Thank you for your interest. I will create the VB form which will provide the user to have three options Review, Edit and enter new client details. The latter two parts I have coded successfully on previous programmes.

I would like guidance to code in VB the following: Review (History) - When the user selects a surname from a dynamic drop menu, say Smith, all the Smiths are then displayed, this also drags in all selected data from a number of selected cells against each Smith. [E.g. Title: Mr, Surname: Smith, Forename: Peter, DOB; 28 November 1990, Address line 1: 3 Springside Cottages.] The users will have the facility to refine the search by selecting from another dropdown menu forename, such as Peter, the screen may still display all Peter Smiths’. The final menu which may be used if there are a number of Peter Smiths’ would be the data of birth drop down. I realise that this can be done by filters, this would be fine if all user had the same basic skill level, this is not the case. I guess I am creating a similar approach which can be done in Access relationship tables. However, the reason I am sticking to excel that the shared users will not all have MS Access as this is not widely available throughout the organisation. MS Excell is. I hope this can be achieved

Many Thanks