Carrying Value from One From/Table to another

R

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
 
B

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top