Get primary key for record on sub form

[Gavx]

I have a main form open.

When I open another form (OtherForm) I want it to get the primary key value of the item listed on the subform of the main form.

In the Open event of the OtherForm I have;

ipkID = Forms!fmMainForm!sbfSubFormControl.Form.CurrentRecord

But it is not working

Or do I have to use recordset?

i should add that this value I am trying to retrieve is not on the subform but is the primary key of the table that is the record source.

thanks
thanks for any help

 

[sneuberg]

If it's not on a form then

pkID = Forms!fmMainForm!sbfSubFormControl.Form.CurrentRec ord

won't do it. Maybe you can get what you want with DLookp https://support.office.com/en-us/article/DLookup-Function-8896cb03-e31f-45d1-86db-bed10dca5937

If want us to show you how to set it up we'll need to know the table name of the record source, the name of the field that is the primary key and what determines which record you want.