How to concatenate values of two form fields to set value of third form field

[BLITZ79]

I have a very simple Access form that will be used to insert records into a SQL database.

First field is 'pvLot' and it is a Combo Box whose values are driven by a separate pvLots SQL table.

Second field 'waferID_slot' is a varchar(3) (in the SQL database) and common values would be '001', '002', '003', etc...

For the third field 'pvCellSerial', I need the form to INSERT to the SQL database a concatenation in a sense. The value in this field should be [pvLot]&"-"&[waferID_slot]. Using the 'Control source' property I can get that string to display on the form, but it appears to be as read-only property as the SQL insert fails as the third column is NULL upon insert.



Novice at SQL development and have used Access for several years but primarily for complex ad-hoc queries, so little experience with forms.

[pbaldy]

It's not the kind of thing I would save, but if you must, it's basically a calculated field:

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