Using VB in an Access form to find copy and paste record

[ashhalhope]

I volunteered to build a database for a professor- am now a little over
my head (Animal Science Major- took a basic programming class and a
class in Access). I will give a general overview and leave out the
nasty details. Any help is greatly appreciated

I have created a form for a lab technician to use during research
projects. We will be collecting samples from these animals. The form
has a field [CollectionNo]- the default for this field is 1. The
maximum an animal will be collected in one day is twice - - so the
collection number can either be 1 or 2. When it is changed to 2- I
need some type of code that will find the record for the 1st collection
of this animal and copy certain fields (for example purposes [volume]
and [concentration] and paste them into the new record (same field
names) for collection 2. I don't know if there's a way to have this
all happen and then the values appear in the form. The technician will
not have the ability to view the underlying table- so they need to be
able to verify the numbers before saving the record.

I was supposed to have this ready by graduation (which took place
today) and this is the last big hurdle I need to jump over before
sending a beta test version to the professor. He was so kind to assign
a grade for me so that I could graduate anyway- provided I finish as
soon as possible.

 

[ashhalhope]

Please help!!!
This is the final step in completing my project and I can't get
anywhere!

 

[Larry Linson]

You haven't given us enough information to assist you -- so repeated appeals
aren't likely to help.

Here is a starting point for providing us with enought information to
_start_ remote debugging. What does your data look like? That is, what is
the Table name? What fields are involved in identifying a particular record
_besides_ the CollectionNo. What are the names of the fields do you want to
copy? What are the names of the Controls on the Form which display the
Fields? What is the RecordSource of the Form?

Larry Linson
Microsoft Access MVP

Please help!!!
This is the final step in completing my project and I can't get
anywhere!

I volunteered to build a database for a professor- am now a little over
my head (Animal Science Major- took a basic programming class and a
class in Access). I will give a general overview and leave out the
nasty details. Any help is greatly appreciated

I have created a form for a lab technician to use during research
projects. We will be collecting samples from these animals. The form
has a field [CollectionNo]- the default for this field is 1. The
maximum an animal will be collected in one day is twice - - so the
collection number can either be 1 or 2. When it is changed to 2- I
need some type of code that will find the record for the 1st collection
of this animal and copy certain fields (for example purposes [volume]
and [concentration] and paste them into the new record (same field
names) for collection 2. I don't know if there's a way to have this
all happen and then the values appear in the form. The technician will
not have the ability to view the underlying table- so they need to be
able to verify the numbers before saving the record.

I was supposed to have this ready by graduation (which took place
today) and this is the last big hurdle I need to jump over before
sending a beta test version to the professor. He was so kind to assign
a grade for me so that I could graduate anyway- provided I finish as
soon as possible.