Control = subForm control

[Guest]

I have a form called IventoryOut which has a control for serial numbers for
reclaimed machines and then I have a subform that is a seperate table that
contains the data for the re claimed machines ( Asset number, Description
etc) which also contains a control for serial numbers for reclaimed machines.

The tables are linked through the Serial number for reclaimed machines field.

When the reclaimed machine comes in the person scans the serial number into
the the [Serial Number for relcaimed machine] filed in the Reclaimed machine
table(subform). I would like it to autopopulate the [serial for reclaimed
machine] field in the inventory table(main form)

I tried some visual basic code as the following

Me.reclaimed_serial_number =
Forms!InventoryOut.InventoryOutSubform.Form!Reclaimed_serial_Number

with no luck?

I am new to coding so I don't understand much, I was also wondering if this
simple task even requires coding.

Any help is much appreciated

Thanks!

 

[Guest]

I don't know if I'm fully grasping your situation, but duplicating data in
this way is often problematic. Almost like storing Totals in a table.

Totals get stored in a Calculated field in a Query, Form, or Report.

I would think that if you want serial numbers to show up in multiple places,
you could also use a query to pull in the serial number from the main table
that relates through the primary ID to the child table.

Another motivating factor (other than the one of having duplicate data in
multiple places), if the serial number is entered wrong, you have to then
change it in multiple places as well.

Hope this helps.