Data from one form to another

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to copy a customer ID number from one form (customer ID is key
from this table) and use this ID in another form/table (can have many ID
entries). I have been able to find an expression to pull current entries,
but can not seem to create a new entry in another table.
 
Melynda,

You could use a macro with a SetValue action to enter the Customer ID
into the second form. Or you could use an Append Query, if this
involves adding a new ecord to the table that the second form is based on.
 
Back
Top