Hello. I am following the Idiot proof Tutorial and have got to Tutorial No 6. with regard finding Data. And have struck a problem. The search box is displayed but when i click Ok the data is not displayed on the Form Instead I get a Header displayed where a name should go and nothing else. Can you help. Also for some reason best known to Excel I cannot seem to get the Form to clear either, it worked upto Tutorial 5.
I have included the Excel Database with this file, with the VBA code. I have not hidden anything as yet but the Form is Protected the passcode is written on the worksheet to the right of the Form. Having followed this series so far I am hoping that this continues in the future.
The ID number I am using is already in place on the worksheet, and application forms received go by the date of the application in the next available space, once entered onto the Form then submitted the data copies to the "Entries" worksheet then onto the start sheet etc.