General discussion


Access 2000

By jimbo ·
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
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
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

This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Comments

Collapse -

by Haris In reply to Access 2000

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.

Related Discussions

Related Forums