I have two forms in a database which share three similar fields, "bid name" "bid location" and "bid date". They are designed to display jobs to be bid, and jobs that are currently bid and waiting results. The "to be bid" form is based on a query and has a yes or no toggle to indicate if the job was bidded. If it has been bidded it will no longer be displayed in the form. What I want to also happen is when it is clicked the three similar fields will be copied to my second form. If you understand what I am trying to explain here and know a way to do this please help. Thank you.
