merging two fields into one (with a twist)

[Callum]

Hi guys, first post

my problem is quite simple (as far as i can tell) but none-the-less i'm stumped.

what i want to do is merge 2 fields into a separate field with the first field being Unique_Id (autonumber, indexed and no dupes) merge with the second field Type (3 letter field) so it should populate the third field automatically as NDE123 etc , but what i also need (which looking around the internet for afew hours held no aveil) is for it to be automatic even when a new records is made, so when a new record is inevitably made the first field will be autonumberd, the 2nd will have a default value, so it will mostly be entirly automatic, is this possible? or am i clutching at straws.

Thanks, Callum

 

[John Big Booty]

It is possible but given that you are already storing both these fields, why bother storing them again as a third combined field?

You can simply combine them for display purposes on your form or report by putting the following in the Control Source of an unbound Text Box;

=[Field1]&[Field2]

You just need to ensure that your two fields form part of the Record Source for your form.

 

[John Big Booty]

Please refrain from double posting