Carrying Value from One From/Table to another

[richard]

I have two tables Batches and Sample Details, The Batch Number is the primary
key in batches and also a field in Sample Details
Currently in Sample Details the Batch Number is selected using a combo box,
however to prevent human error there is a need to have the field filled
automatically and all subsequent samples allocated with that batch number.
My thoughts are to have a command button within the Batch form which states
"enter samples for this batch", which will open a form where the batch number
will be fixed until another command button within the Sample Details form is
clicked which states "Batch Complete"
Thoughts and help please

 

[Bob Quintal]

=?Utf-8?B?cmljaGFyZA==?= <[email protected]>
wrote in

I have two tables Batches and Sample Details, The Batch Number
is the primary key in batches and also a field in Sample
Details Currently in Sample Details the Batch Number is
selected using a combo box, however to prevent human error
there is a need to have the field filled automatically and all
subsequent samples allocated with that batch number. My
thoughts are to have a command button within the Batch form
which states "enter samples for this batch", which will open a
form where the batch number will be fixed until another
command button within the Sample Details form is clicked which
states "Batch Complete" Thoughts and help please

If you redesign the Batches form to include a subform bound to
the SampleDetails table, it will allow you to automatically
enter the samples info for the batch, automatically (if set up
correctly) linked to the correct batch. Additionally, as you
navigate through the batches form, you immediately see the
samples data.