Hello everyone.

It has been a long while since I have been here so, it is great to be back.

Anyway, I have a little problem that I need to solve, not right away, but it would help the company that I am working for. Here is the exact image of what I am working on:

Rechercher.png

I hope the image is good.

Anyway, if not, I have added 7 text fields and 7 labels, with 2 command buttons at the bottom and I have tried to create some vba text that will enable the user to either add new data to the existing table, or even do a search which will bring up the records. I am at a loss at the moment, and with your help, I hope I can create this database and make it user friendly. This userform will be linked to an excel spreadsheet with some 15,000 records. It would be great to actually show the historical events of a particular archive too.

Many thanks in advance.