Hi, Simple problem but cant get my head around it. I have a couple of forms and tables. One table contains the orders including an Order ID (OID) and a Customer ID (CID).
When the user Doubleclicks on the CID field in the Forms!Orders it opens Forms!ChangeName containing just the OID and a CID Field (With Name,Phone,Account Displayed instead of the Number)
I have got it to save the Record and insert the updated data into the Orders Table but have not been able to get it to update the Orders Form without going back to the first record.
How can I get the Orders form to point to the current record after the change?
When the user Doubleclicks on the CID field in the Forms!Orders it opens Forms!ChangeName containing just the OID and a CID Field (With Name,Phone,Account Displayed instead of the Number)
I have got it to save the Record and insert the updated data into the Orders Table but have not been able to get it to update the Orders Form without going back to the first record.
How can I get the Orders form to point to the current record after the change?
