Data from one form to another

[Melynda E.]

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.

 

[Steve Schapel]

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.