Double Booking Problem

[atc]

Thanks for your continued help.
With this code is place (entering the data courtID of 1 and a date of 01/03/2007 - not a duplicate) I get the same message as before but when I click ok it keeps the courtID of the new record, deletes the schedule date and moves to courtID of a new record below.
I also get the same result if the data is a duplicate.
ATC

[NeoPa]

John,
This is not really the thread to discuss this code.
I suggested that code in a completely different thread and half of it is simply to give debug information. It is not finished code. To work with someone else on this code is not good. How do you expect me to progress it with you if you get changes from outside sources.
If you want me to stop then please just let me know, otherwise I would appreciate being given the chance to deal with it without extraneous influences complicating matters even further (back in the original thread). Quite apart from anything else, the original thread will be no use as a reference if it stops dead in it's tracks half-done.

[atc]

Ok sorry NeoPa i thought two heads may be better than one. I'll post in the orginal thread.
john

[NeoPa]

Ok sorry NeoPa i thought two heads may be better than one. I'll post in the orginal thread.
john

Thank you.
(Stop Duplicates) in case anyone wants to come over.
It's probably best though, within such a tight debugging loop as this one, that the two of us focus together unless and until we find we can't sort it. Extra heads in a situation like this is more likely to distract than help.

[MMcCarthy]

LOL - Are you calling me a distraction Ade.

John

In this case he is quite correct as I was unaware of the other thread I was missing half the information. NeoPa will call me in if he needs any futher assistance although I doubt it. He's really quite good just don't tell him I said that.

Mary

[NeoPa]

New post moved to it's own thread (Access 2007 Template Appointment Manager)

PS. Never mind. Not only a hijack but also a double-post. Presumably a new user of forums. Anyway, the remaining thread is found at tennis court booking database.