I have a form that pops up (in datasheet view) when a customer is added to an order that shows all previous Shipping locations for the specific CustomerID. I would like to be able to double click on the ShippingID and have that populate on the original form. I assume this is a "on double click" event, but I dont know the vba to select the item I just clicked on and then add it to form.field of my choosing.
Thank you in advance for any helpful information.
-Matt