Programming Help Please A97

[Ken Reay]

Hi

Have you tried using an SQL statement of the form:

INSERT INTO tablename SELECT f1, f2, FROM Tablename;

without knowing your table names, criteria etc cannot give
exact syntax

Hope this helps

Regards

Ken Reay

 

[Paul]

Thanks for the response Ken

I have tried using queries to insert the order number and shipping method
into the next row of my table Bulk Order but cannot figure out how
to activate this via the check box.
Briefly my form is in a tabular format listing all of our products and
carrying order header information, a check box tick allows a user to
multi select the products required. I had hoped that using delete &
update queries referencing the check box in a yes state would carry down
the the Order No & Shipping method to the subsequently checked rows.The
form control is from a table called Bulk Order

The design and structure of my db is very basic, reflecting my skills, so
far, but I am hoping that using Access will go some way to making
what is a very long winded job quicker

Thank you for your support


Patrick