Sorry it took so long to respond to all of you..
I finally got this to work the way I wanted... I used the
click event on subform1 and created an append query that
add the records. I just click on the record I want to copy
which saves 2 columns(PartNo & SeqNo which is an auto number field)...
This seems to work a little better than the other way I was doing it.. However my code always changes the first record in the PO table instead of adding a new record.. I am using the docmd .... acnewrec... with data saved in global variables..
any other suggestions ????
if you have an example...
Hello everyone,
I have a main form with text boxes that are used to create
new records in the Parts table and displayed in subform1. The part number on the main form shows all duplicates in subform1.(duplicates allowed -- user required) This part works fine...
The PoNumber text box on the...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.