I'm definitely doing this wrong and I've Googled and Googled and I can't seem to find an answer so I'm hoping someone can help me.
I have a new Client form where I want to pull the last 4 digits of the phone number to create the customer number.
In the customer number field I have placed the code =(Right([Main Phone],4) into the Property Sheet > Control Source which pulls the last 4 digits of the phone number.
The issue is that this number is not saving back to the table. Can someone tell me how if I've placed the code in the right place and how I would get this code to save back into the table?
I may be going about this totally backwards, I'm not sure!
Thanks so much!!