thank you for the replies. there is no primary key as duplicates are allowesd I could try defining one though. I'm not back at work until monday so I'll do it then.
hi, I hope you can helped as I'm stumped.
I have a form where if a date is entered it generates a follow up record on another table. It works perfectly when you select the date from the calendar popup but if I enter or change the date manually it creates a duplicate record. I've changed the...