Originally Posted by
todmac
...I was able to use a calculated field to produce it however because it assigns the value to an unbound field it appeared in every record the user tried to input (needs to be unique to each claim number)...
Instead of assigning it, as you are now doing, to make the Unbound Control be Record-appropriate, you need to place your Calculation in the ControlSource Property of the Unbound Textbox, preceding it with the Equal Sign.
Linq ;0)>
The problem with making anything foolproof...is that fools are so darn ingenious!
All posts/responses based on Access 2003/2007