I need to combine to fields in a table to populate a third field

[Guest]

I have two fields that need to be concatenated to form a third field which is
used as a primary field. The data for the first two fields is typed in on a
form, and the combined data needs to be added to the table.

 

[Duane Hookom]

Why not just store the two values in two fields? Storing a calculated value
is rarely justified and mostly unnecessary.

 

[Corey-g via AccessMonster.com]

This would depend on how you wanted to handle this, either in the text box,
or using VBA code.

If you had 3 textboxes, you could do this as the control source of the 3rd
textbox:
=[textbox1]+[textbox2]

If you are using VBA, using whatever event procedure that works for you, you
simply use:
me.textbox3.value = me.textbox2.value & " " & me.textbox2.value

HTH

Corey

 

[John Vinson]

I have two fields that need to be concatenated to form a third field which is
used as a primary field. The data for the first two fields is typed in on a
form, and the combined data needs to be added to the table.

No, it doesn't, almost certainly.

You can make two fields (or ten fields for that matter) a joint
Primary Key by ctrl-clicking the fieldname in table design so that
they are both selected and then clicking the Key icon.

It is neither necessary nor desirable to store the information in the
two fields redundantly in a third field.

John W. Vinson[MVP]