Data not fixed in Combo Box

[John@backacre.co.uk]

I have used the Northwind Order Entry form as a basis for a project. All seems OK until the user accidentally uses the Combo to start a new order without first selecting a new record. The results could be disastrous as the wrong company would get the wrong order. It happens in the Northwind database too!
So I tried to block the combo from working if a company name already exists on the form but withiut success. It seems such an obvious problem that a solution should be available and indeed it should be included in the MS sample database!
An answer to this would be very welcome as my user is having kittens in case the operator causes a problem.

 

[PNGBill]

Without looking at Northwind, you could add a MsgBox to the combo box asking the operator if this order is for a new client etc.
If you have the MsgBox as a Response, then the vbYesNo and an if Then can force the operator to select a new client.
Maybe with SetFocus to the correct combo box for selecting a client.

 

[John@backacre.co.uk]

Thanks for your suggestion PNGBill, I hadn't thought of that one. After thinking a bit more about your suggestion, I might try a got focus event to open a new record if there is already an entry, because the combo on the Northwind form is the means of selecting a customer for a new order. I'll try that and let you know.