I have a table (tblCustomer) that has the field LastTrans I want to use VBA to send ShipDate from the frmOutgoingServiceOrders after it has been entered or updated. It will need to replace the previous date in the customer table. The CustCode is the primary key in tblCustomer and the tblServiceOrders is linked by CustCode. I need LastTrans to be updated each time an order goes out so that we can tell if a customer is still active in sending us repair work to do.
It seems a simple problem but I don't know VBA that well yet and I cant figure it out. Any suggestions ?