Append query duplicates if date entered manually (1 Viewer)

I

Incurable Trekkie

New member

Local time

Today, 03:16

Joined

Aug 9, 2018

Messages

2

• Aug 9, 2018

• #1

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 dates to short date in case it was the time element that was causing it but it made no difference.
Any ideas?

 

jdraw

Super Moderator

Staff member

Local time

Yesterday, 22:16

Joined

Jan 23, 2006

Messages

15,379

• Aug 9, 2018

• #2

Creation of duplicates suggests you do not have a proper Primary key on your table.

 

arnelgp

..forever waiting... waiting for jellybean!

Local time

Today, 10:16

Joined

May 7, 2009

Messages

19,231

• Aug 9, 2018

• #3

don't you have any validation on the date textbox to check if the date is already in the second table.

 

I

Incurable Trekkie

New member

Local time

Today, 03:16

Joined

Aug 9, 2018

Messages

2

• Aug 9, 2018

• #4

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.

 

MarkK

bit cruncher

Local time

Yesterday, 19:16

Joined

Mar 17, 2004

Messages

8,179

• Aug 9, 2018

• #5

Incurable Trekkie said:

I have a form where if a date is entered it generates a follow up record on another table....
Any ideas?

Click to expand...

Show your code. Describe your process exactly. We can't troubleshoot a specific problem from this vague a summary.
hth
Mark