I have a form which contains a combox box and a text box. The combo box allows the user to select a record from
a table. The text box allows the user to enter a new job number. The key field in both the linked table and the
resulting table is "JobN". "JobN" is actually a text field.
Also on the form is a command button. When the command button is clicked (after the user has selected the
record we want to copy to the resulting table and the user has also entered a new identifier in the text box),
I want the selected record to be copied to the table but use the newly entered identifier in the "JobN" field.
The name of the combobox field is "cboOrigJobN". The name of the new text box is "txtNewJobN". The name
of the table that contains the record to be copied as well as the new record with the new key data is "tblJobScheduleHeader".
I can't figure out how to make this happen.
--Steve
a table. The text box allows the user to enter a new job number. The key field in both the linked table and the
resulting table is "JobN". "JobN" is actually a text field.
Also on the form is a command button. When the command button is clicked (after the user has selected the
record we want to copy to the resulting table and the user has also entered a new identifier in the text box),
I want the selected record to be copied to the table but use the newly entered identifier in the "JobN" field.
The name of the combobox field is "cboOrigJobN". The name of the new text box is "txtNewJobN". The name
of the table that contains the record to be copied as well as the new record with the new key data is "tblJobScheduleHeader".
I can't figure out how to make this happen.
--Steve
