Import log that searches for previous matches

[Fugitivepete]

Firstly Apologies if this has been answered elsewhere on here, but I have had a looka nd cant find quite what I was after.

I have a form, that once completed and sent to me, I can import the information from the form to a log that I have, from a button that rus an import macro and does a few other things (automatically assigning it reference numbers, initials and a calculation). The macro then takes teh assigned number from the log and populates an area on my form (which I can then save and pass to someone to process).

The problem I am having, is that when the process was manual, it would try and autofill where a customer had been entered previously and now it runs off a macro it doesnt give me the option to catch previous requests. I am finding that on occasion I am now logging customers twice.

I am after creating a search function that finds all previous customer matches from a column and then brings back the results in a msgbox and offers the opportunity to assign a previous reference number to the form (based on the choices presented).

I want to be able to search without exact matches as well if possible.


I would be creating this as a new procedure, so that I can call it from the macro I am running, because I have another macro taht I would like this procedure for as well.

Does anyone have any ideas for how best I could do this?

Thanks in advance!

Pete