This is about adding serial Numbers into subfrom filed curretly i have form and subfrom and another subfrom
subfrom no 1 is called cmostime base on cmostime table consist of QC,starttime ,endtime,qty,workorder qc filed is base on qc table as combo box which qc can drop down thier numbers, like qc1 , qc2 etc enter time and date and so on.
subform no 2 is serial form base on serial table consist of qc combo box , serial number field and work order like previos form which qc can use combo box and enter many serial number . so far data base working fine time comsuming part is when qc try to add serial number with add new record also has to select his qc id from the combo box with every serial number i like to get rid of subform no2 and add serial number filed to subfrom no1 and on clik propery open serial form to enter serial number my problem i want qcid field remain constant while all seril numbr have been added example qc id 1 choose his id enter start time and stop time ,clik on added serial number field and enter many serial number which will be under qc id 1 when i open serial table i be able to see these serial number have been enter by qc id 1 any help greatly Appreciated
This conversation is currently closed to new comments.
hi, Once the qc has selected his id store it in a global variable. Assign this value to the id data control on the Add New record form.
Another option is that when the Add new form opens you can still refer to the form where qc entered the id (if that form is still open). refer to that control to read id or make it the data source of Add new form for id.
Access wizard also allows storing values for later use.
If you're asking for technical help, please be sure to include all your system info, including operating system, model number, and any other specifics related to the problem. Also please exercise your best judgment when posting in the forums--revealing personal information such as your e-mail address, telephone number, and address is not recommended.
Access 2000
curretly i have form and subfrom and another subfrom
subfrom no 1 is called cmostime base on cmostime
table
consist of QC,starttime ,endtime,qty,workorder
qc filed is base on qc table as combo box which
qc can drop down thier numbers, like qc1 , qc2
etc enter time and date and so on.
subform no 2 is serial form base on serial table
consist of qc combo box , serial number field and work order like previos form
which qc can use combo box and enter many serial
number .
so far data base working fine
time comsuming part is when qc try to add serial number with add new record also has to select his qc id from the combo box with every serial number
i like to get rid of subform no2 and add serial number filed to subfrom no1 and on clik propery
open serial form to enter serial number
my problem i want qcid field remain constant while all seril numbr have been added
example
qc id 1 choose his id enter start time and stop time ,clik on added serial number field and
enter many serial number
which will be under qc id 1
when i open serial table i be able to see these
serial number have been enter by qc id 1
any help greatly
Appreciated