J
jbair via AccessMonster.com
I have a table with a primary key(no duplicates) for an order number I have
three forms one for parts pull, one for assembly and one for test . I want to
be able to start the record at parts pull with the primary key and then with
a scanner enter the order number and add info to the record and then do the
same thing in the test area. What I need to do is to be able to update the
record. But I can't because I get duplicates not allowed message. I believe I
am going about this wrong.How do I make the order number field on each form
find the exsisting record and open it so it can be updated?
Thanks
JBair
three forms one for parts pull, one for assembly and one for test . I want to
be able to start the record at parts pull with the primary key and then with
a scanner enter the order number and add info to the record and then do the
same thing in the test area. What I need to do is to be able to update the
record. But I can't because I get duplicates not allowed message. I believe I
am going about this wrong.How do I make the order number field on each form
find the exsisting record and open it so it can be updated?
Thanks
JBair