Hi Richard
The thing is I HAVE been building the database as I go along ??
Tried your suggestion but no joy. In fact, I tried the same thing on another laptop of mine with Access 2010 installed and still got the same thing.(although, admittadly using a copy of the database I mAde on the first laptop)
I've been over and over your video a good few times and tried to follow it as perfectly as I can.
Not sure if this matters but I need to use "Double- double " quotes in the CompanyNameSearch combo box , to get it to work !! Also, while the embedded macro for thIS combO box seems to work on the customerF form (ie it will change the record based on company name), if I run the macro on its own it still says "Type Mismatch"
It's driving me crazy so any other help very much appreciated.