G
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!
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!