I'm trying to create the where clause for this, but I'm having trouble.
My situation is, I have a form (frmViewProvider) with a subform (subfrmNotes) in datasheert view on it. Upon clicking on the primary key (NoteID) on the subform, I'd like the form formViewNote to open dialog.
Here's what I've tried
Where = ="[NoteID]=" [Tables]![tblNotes]![NoteID]
I'm sure it would be easier in VBA, but I've barely scratched the surface to with VBA, so a Macro seems easier to me.
What am I doing wrong?