G
G Lam
Hi, I am using Access 2000 and learning to write VAB codes. I have a form
for data input. The form and its underneath table has 4 fields: ProdID,
BinNbr, EmpeId, and Date.
The ProdId and BinNbr combined a mutilple fields primary key. An employee
may need a few bins to contain a day's work. If only the BinNbr field has to
increase by 1 for a new record, how can I insert the data from a just saved
record to the new record in the input form by just increase the the BinNbr
by 1?
I tried to use variables to hold the field values before saving the record
and then used the variables to insert data to the new one. But seemed that
the variables lost their values once the form refreshed to a new record. I
checked that in the immediate window.
Gary
for data input. The form and its underneath table has 4 fields: ProdID,
BinNbr, EmpeId, and Date.
The ProdId and BinNbr combined a mutilple fields primary key. An employee
may need a few bins to contain a day's work. If only the BinNbr field has to
increase by 1 for a new record, how can I insert the data from a just saved
record to the new record in the input form by just increase the the BinNbr
by 1?
I tried to use variables to hold the field values before saving the record
and then used the variables to insert data to the new one. But seemed that
the variables lost their values once the form refreshed to a new record. I
checked that in the immediate window.
Gary