Update table based on concatenated field

[qwerty99]

I have a field in a table that is to be concatenated from two other fields, PolPrefix and PolNum. On a form I got it to show the full field 'PolicyNumber' by making the control source =[PolPrefix] & [PolNum]. But this doesn't update the field PolicyNumber in the respective table, and only shows it on the form. How do I get a concatenated field defined by the user into a table so that I can call that field other places in the database?

 

[pbaldy]

http://allenbrowne.com/casu-14.html

 

[qwerty99]

Beautiful. Thanks for the quick reply.

 

[pbaldy]

No problemo.