How do I auto fill a field based on info input into another field.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have two subforms in a form each from different tables. I want to generate
an autonumber in one sub form and have that number be input into another
sub form that will in turn enter that number into its related table. I have
tried the VBA code equating the two fields and I have created a macro. I
have put the event procedure (and different try- the macro) in the
properties of the second field that I want to recieve the number in Event as
ON Click - expecting the field to update when I click on that field. It
doesn't seem to be working. Is this possible? I don't know VBA . I would
apprecizte any help I can get.
 
On Tue, 19 Apr 2005 15:07:01 -0700, "Brenda F" <Brenda
I have two subforms in a form each from different tables. I want to generate
an autonumber in one sub form and have that number be input into another
sub form that will in turn enter that number into its related table. I have
tried the VBA code equating the two fields and I have created a macro. I
have put the event procedure (and different try- the macro) in the
properties of the second field that I want to recieve the number in Event as
ON Click - expecting the field to update when I click on that field. It
doesn't seem to be working. Is this possible? I don't know VBA . I would
apprecizte any help I can get.
Click to expand...

Simply make the textbox containing the autonumber the Master Link
Field of the second subform: use the full syntax

[Forms]![mainformname]![firstsubform].Form![controlname]

in the Master Link Field property of the second subform.

No macro and no code needed.

John W. Vinson[MVP]
 
Back
Top