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
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