determine selected row in subform 1

[Apollo13a]

Hello, How can I get the primary key of the row selected in a subform? I have a subform linked to my main form using a field called TicketNumber(not the primary key). My subform has fields as follows: tblReferralID(Primary Key), StartDate, Contractor, TermDate, TicketNumber,ReferralComplete(Yes/No). The subform is based on a different table than the main form(although they have relationship using TicketNumber) When a user selects a record in a combobox(main form) the subform displays all records where the ReferralComplete = No or false. I also have code to change the subform property of Data Entry to No so I can show all the open referrals. Then a user can enter a Term Date for a referral to close out the referral. I need to know which record the user has entered a Term Date for to do some other actions in the Db. My current code always returns the Primary Key first record in the subform. I guess I could do a Dlookup using TicketNumber, StartDate and Contractor but I would like to use the Primary Key field. Any suggestions?
Jim

 

[PHV]

In the BeforeUpdate event procedure of the subform:
If IsDate(Me![Term Date control])
MsgBox "tblReferralID = " & Me![tblReferralID control]
End If

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[Apollo13a]

works great
thank you