I'm sure this is super simple and I'm just over-thinking.
I have a tabbed form with subforms on each tab. They all update how they are supposed to. I want to put a command button on one of the subforms that will open according to the record that the subform is currently on. I tried just doing the normal wizard, didn't work. So I looked online for some code and this is what I found:
Private Sub cmdOpenGrowerInforpt_Click()
DoCmd.RunCommand acCmdSaveRecord
DoCmd.OpenReport "rptGrowerInformation", acViewPreview, , "[GrowerID]='&"
[GrowerID]
End Sub
I bolded that last part because it's whats causing the code not to run. I don't know what I should be putting there to make it work. Hopefully I'm making sense. Any help would be great. Thanks!