How do you refer to primary key on split form?

[techneophyte]

I'm using a split form in Access 2007. The bottom part of the form shows the table that is linked to the form. When the user clicks on one line in the table, I want to update that specific line. in order to do that I need to grab the primary key for that line to use in my code. What's the syntax for referring to the key specific to that line?

Many thanks.....it's giving me a headache

[NTC]

The split form, introduced in Access2007, provides 2 simultaneous views of the same record set (table or query). I'm not sure you mean by 'refer to primary key'. In the split form one doesn't need to refer to it.

Perhaps you a refering to a subform - where the data in the subform is a differing record set then the main form. In which case one needs a cross referencing value in both record sets. In this case - when you insert the subform into the main form - the wizard will ask you the cross referencing fields - and when you add data to the subform it will automatically insert the value from the main form.

[Access_Blaster]

Take a look here

[techneophyte]

I have a form that shows the entry boxes on the top, and then the split form shows the same fields in the underlying table at the bottom. so when the user enters data in the upper form, it is saved in the table showing at the bottom.

however, I need the user to be able to select a line in the table at the bottom and then be able to modify the data. usually they are going to add an attachment. I need to get the primary ID of the line that they clicked so I can then connect the attachment specifically to that line