I have the following code as part of a command buttons onclick event:
DoCmd.OpenForm "Adult MIF subform", , , "[Member ID]=" & Me![Member ID], , acHidden
The whenever I click the button, I get "The OpenForm action was canceled." message and then nothing happens.
Probably something easy, but this used to work until I added the where clause part, so its probably something with that part of it. Any ideas as to how to fix this? I want the subform record related to the current main form record to open in the background for some other processing.