SubForm

T

tankerman

In my form I have a subform that gets some of it fields filled from the main
form, my "TicketID" in my subform gets filled from the main form as well as
2 others and I'm getting the message that the changes I requested would
create a duplicate value. In my main form "TicketId" is set to NO DUPLICATES,
but my subform is set to YES DUPLICATES OK

My subform is for delays and from time to we will have more than one delay,
when we have only one delay that I fill in the subform fields I DO NOT get
the duplicate message just when I have to enter more than one delay.
 
T

tankerman

Never mind I got it, took the Primary Key off of "TicketID", inserted an
autonumbering field and Primary and it now works

THANKS anyway becasue this forum has been a great help in the past.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Populate main form from subform record 0
Problem with form--subform 5
Calculating... 4
Request Form - Alert Team Member 0
Omit Duplicates in query 6
primary key - concatenated or autonumber? 6
Link subform ID control 3
Adding data to MS Access from csv file 0

Top