"Detail" button on continuous form -- How can I link it to the specific record?

[WesHarding]

Oh my god I got it. FINALLY.

I thought it out, it was as simple as me having my parent and child fields backwards.

Private Sub Command77_Click()
DoCmd.OpenForm "sfrm_farm_detail", , , "DetailFarmerID = " & Me!FarmerID


End Sub

Finally. Thank you very much for the patience and help literally all afternoon aytee111, I appreciate it a lot. You are what makes this such a great forum website

[aytee111]

Thank you for your kind comments. Glad you were able to sort it out and get it working - those instructions were in post #2!!!!

[WesHarding]

lol, I was so muddled in frustration I didn't take time to look and read, I was like a robot copying and pasting. Take care