Using a value on a report for a query (1 Viewer)

katzi4eva

Registered User.
Local time
Today, 06:23
Joined
Nov 26, 2014
Messages
14
Hi

I have a report when i send units back to the customer, the report generates an ID in a list box (a query picks the last ID used and adds 1)

after the report prints i use an update query to mark the units as "shipped" with the dates in the main table. i need the update query to use the value from the list box to update the value in the table.

any ideas? probably looking me in the face but cannot sort it!

Many thanks :D
 

katzi4eva

Registered User.
Local time
Today, 06:23
Joined
Nov 26, 2014
Messages
14
sorry i didnt explain very well.

i use one form to select items using checkboxes to send back to my customer.

i click a button on the form to generate a report to accompany the units. also in the code for the button i run a query which updates yes/no fields to mark as shipped within my main table (tblunits) and the date shipped.

the report on loading takes the last ID from another table, tblshippers, and adds 1 to create the new shipper ID.
i need this ID value to be added to the main table for the units shipped in that load.

there is another query which updates this table (tblshippers) with the total number of units shipped, the date, shipper id.

hope thats a bit clearer?
 

Users who are viewing this thread

Top Bottom