Controls and Combinations

[Warwick Hunt]

Hiya All.

I need an answer to the following question.

I hae three fields. Field 1 contains ICA, Field 2 is an Autonumber Field and
Field 3 is to ho0ld the contents of Fields 1 and 2. So Fiels 3 would contain
ICA1

Everyway I have tried thus far has failed (Hence this post) Can someone help
me please ?

TIA

Dave

 

[dan artuso]

Hi,
Set the control source of the text box to:
=NameOfField1 & NameOfField2

For future reference, it always helps if you post the actual names of your controls
and fields etc

 

[Warwick Hunt]

Thaniks for the suggestion. But this still did not work...

Any others ??

Cheers

D

 

[dan artuso]

Hi,
Can you post exactly what you put as the control source?
The method I posted certainly will work. You are talking about
a form here, right?
If you're talking about doing this at the table level, you can't.

 

[Warwick Hunt]

Dan,

It is a form. I have a standard text field ICA and a second field
(Autonumber) called ICAPart2,
I want to combine these and put them into ICARecord (text Field)

Regards

Dave

 

[Van T. Dinh]

What you are trying to do violates the Principles of Relational Database
Design Theory. The 3rd Field is a Calculated Value that can be derived from
the values of the other 2 Fields. The RDDT generally prohibit storing
Calculated Values in the Table.

If you need to display the concatenation of the values from the 2 Fields,
simply use a (calculated) as per Dan's advise but don't store this
calculated value in the Table.

 

[ken h]

If you must do it - On the after update event on the first two flds, combine them and save them to the third fld...

me!ICARecord = me!ICA & me!ICAPart2

But - Keep in mind that if you ever edit either of these two fields anywhere else, then the third field will need to be udated...

Ken -