naming a primary key when there are > fields

T

Ted

hi,

i would like to reference my PK in an expression like

Me.txtCurKey = Me.nameofPKfield

where the nameofPKfield refers to a PK consisting of five fields in the
form's underlying table: LastName,FirstName,MI,MR_Number,IRB_Number

looking at the listing of the PK in the table's properties shows me a
default name of "PrimaryKey" in the column labeled Index Name, but that
doesnot in VBA code.

so, what is the name of the PK?
 
D

Douglas J. Steele

You've got an index on those 5 fields, and the index will be named
PrimaryKey, but it's not as though there's a single field that contains the
concatenated value of those 5 fields.
 
Top