Combining two fields into a third one in a Form

[udigold1]

Hi,

I have table with 3 fields, where the combination of the first two fields, which are numeric, make up for the third field, which is a string.
for example:

SystemID SystemChannel ID_Channel 1 2 1_2 2 1 3_1 2 2 2_2

Field 3 is unique so it is the primary key, and since that, it cannot be a calculated field.

How can I make a Form that just entering the first two fields will trigger the completion of the third one (I don't want to type it because fear of typing mistakes)?



Thanks!

[ranman256]

on the form , put these events in:

sub SystemID_Afterupdate
SetID
end sub

sub SystemChannel_AfterUpdate
SetID
end sub

Sub SetID()
ID_Channel =  SystemID & "_" & SystemChannel
end sub

[pbaldy]

In the after update event of the last one they enter:

Me.ID_Channel = Me.SystemID & "_" & Me.SystemChannel