Edit existing fields when creating Microsoft Access Form

[redsquad3]

I'm trying to make a form where you can input an existing equipment and module and then input a new existing equipment and module, so for example lets say for the existing input I put Extractor for the equipment and M1 for the module and for the new input I want to put Extractor 2 and module M3. I want it to duplicate all the existing records on the table that have the Extractor as the equipment and the M1 as the module for the new input that I just put (which would be the Extractor 2 and the module M3) and then append the new duplicate records to the table.





I'm making the form based on this table

[ranman256]

a select query inside an append query.
the select query pulls the items to be copied,
the append query appends this (and any additions/changes) to the target table.

[June7]

Duplicate thread https://www.accessforums.net/showthread.php?t=72114