I need a Field to automatically generate a record in Access

C

Corey Keller

I deal with personel issues with a union. When these guys place "bumps" into
a new position, I need one field in a record to auto generate a new record.
As an example, when one person exercises their senority to take another
persons assignement, I am tracking various information, including the person
that is getting "bumped". This person in turn needs to have a new record
started for them. I need access to autogenerate a new record when I enter
information into one field of a record. Is there a way to do this?
 
J

John Vinson

I deal with personel issues with a union. When these guys place "bumps" into
a new position, I need one field in a record to auto generate a new record.
Click to expand...

Well... a *field* can't "do" anything. It is simply a place to store
data. A table field doesn't have any events and can't cause anything
to happen.
As an example, when one person exercises their senority to take another
persons assignement, I am tracking various information, including the person
that is getting "bumped". This person in turn needs to have a new record
started for them. I need access to autogenerate a new record when I enter
information into one field of a record. Is there a way to do this?
Click to expand...

If you're using a Form, then a control on a Form *does* have events
which can do things (table datasheets don't). You'ld need to use the
Form's (or the control's) AfterUpdate event. It's not clear to me
where the information is coming from or going to, but I'm guessing
that your form event might run an Append query to copy data from one
table into another.

Post back with some more details if this isn't clear!

John W. Vinson[MVP]
 
C

Corey Keller

Thanks John. In regards to a follow up. When I referred to field, I meant a
field in a form. What I am trying to accomplish is when information is
entered into one specific field on a form, access automatically starts a new
record, and automatically copies the information from that field to a related
field in a new record. For instance, if I have a record in a form with Field
A, Field B, And Field C, when I enter information into Field C, Access
automatically assums that a new record needs to be started, and copies
information from Field C into the new records Field A. I am going to check
into your afterupdate event to see if that works. Thanks!!

Corey
 
Top