Automatic Update

  • Thread starter Thread starter Ha
  • Start date Start date
H

Ha

Do you know a macro or event procedure that can copy data
from one field of a form to another field on a different
form? I don't want to have to do it manually.

For example, I have two forms. Form1 has an EventID that
is an autonumber. Form2 also has an EventID. These forms
are separate tables and they both linked to the EventID.
I want to copy Form1 EventID to Form2 EventID without
having to manually typing it in.
 
Do you know a macro or event procedure that can copy data
from one field of a form to another field on a different
form? I don't want to have to do it manually.

For example, I have two forms. Form1 has an EventID that
is an autonumber. Form2 also has an EventID. These forms
are separate tables and they both linked to the EventID.
I want to copy Form1 EventID to Form2 EventID without
having to manually typing it in.
Click to expand...

Well, the forms aren't "tables". They're forms. My window shows the
Owyhee Mountains (well, today they show fog, but usually...) but they
aren't mountainous themselves.

The simplest way to link the forms to carry over the EventID is to
make Form2 a Subform of Form1. You can open Form1 in design view and
just drag Form2 from the Forms tab of the database window onto it, or
use the toolbox Subform tool.

Otherwise, you'll need to use VBA code. It's doable, but it's a bit
complex and is usually NOT necessary. Post back if you feel that
Subforms won't do the job for you.

John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps
 
Back
Top