Generally it is quite simple to schieve with the following code.
Me!PrevLocation = Forms![frmRefCase]![frmRefCaseSF].Form![RelocStore]
However, there is a little twist. The relocStore is actually a drop down with a bound field to a numerical number with 4 columns. I like to copy the rest of the infs in this field as it is visible to me. For example it is the store number as the bound field but I see it as 5556: Wentoworth.
Wondering if there is a way to achieve this?
Me!PrevLocation = Forms![frmRefCase]![frmRefCaseSF].Form![RelocStore]
However, there is a little twist. The relocStore is actually a drop down with a bound field to a numerical number with 4 columns. I like to copy the rest of the infs in this field as it is visible to me. For example it is the store number as the bound field but I see it as 5556: Wentoworth.
Wondering if there is a way to achieve this?