Hi everybody
In a sub-form I am attempting to concatenate two fields, storing the result in another field in the sub-form, and indeed in the same table.
The two fields that are being concatenated are primary primary keys of two tables, and the resulting concatenated field becomes a primary key to be used to link to another table.
The attempted VB code is
[ATR ID].Value = [AT ID].Value&[Resident ID].Value
on an updating event of selecting the [AT ID] value from a combo box.
I'm choosing to do it this way with text ID fields - rather than autonumber fields.
Any ideas please.
Cheers
Peter M