I have a database that contains tickets, the main table is the general ticket information (Table1); then I have additional Tables that contain specific types of tickets (Table2) and (Table3) where additional information is stored only for specific ticket types. Table2 and Table3 are not related to each other and tickets in Table1 may not have a record in either Table2 or Table3.
The relationship is the ticket#.
The Table1.ticket# field is the primary key in Table2.ticket# and Table3.ticket# (using a drop down list of available ticket#’s).
When I select the Table2 button from the Table1 form, I would like to open the Table2 form to a New Record and copy the field value in Table1.ticket# field to Table2.ticket# field, and the Table1.section field to Table2.section field.
I have been able to copy other information on the same form using the below but this doesn’t seem to work with going from Table1.Field1 to Table2.Field1.
‘Copy Field1 to Field2
Me.Field2 = Me.Field1
I figures I was missing the piece for the Form since “Me” references the current form.
Also, if both forms are open and I would like to copy multiple fields from one form to another, do I have to modify anything?
i.e. Change all of these with a single button click?
Table1.fieldA = Table2.fieldA
Table1.fieldB = Table2.fieldB
Table1.fieldC= Table2.fieldC