J
John G
Hi,
I have a form/subform for Bin numbers and activities. On the main form is an
unbound search box and a bound combo box for Bin numbers. The subform shows
all activities related to the Bin number selected on the main form. No
problem. On the subform is a command button to run code that duplicates some
of the data of the subform record and creates a new record for the same Bin
number. Works great thanks to Allen Browne's code! What I would like to be
able to do is duplicate some of the data again and select a different Bin
number than create (or append) to a new record under the newly selected Bin
number. In other words duplicate some data, hold it while I change the main
forms Bin number, then append the data in the subform. How can I edit the
code for duplicating the data so it doesn't append to the same Bin number but
to a different selected Bin number?
Thanks in advance.
I have a form/subform for Bin numbers and activities. On the main form is an
unbound search box and a bound combo box for Bin numbers. The subform shows
all activities related to the Bin number selected on the main form. No
problem. On the subform is a command button to run code that duplicates some
of the data of the subform record and creates a new record for the same Bin
number. Works great thanks to Allen Browne's code! What I would like to be
able to do is duplicate some of the data again and select a different Bin
number than create (or append) to a new record under the newly selected Bin
number. In other words duplicate some data, hold it while I change the main
forms Bin number, then append the data in the subform. How can I edit the
code for duplicating the data so it doesn't append to the same Bin number but
to a different selected Bin number?
Thanks in advance.