Hi all,
I'm trying to set up a button to open a form (example: Form_1![Person ID]) that filter the results of the opened form based on the contents of a field [People_ID] on the form the button exists on (example: Form_2). I have the following code:
This code works, but only some of the time. It's really odd, but when I restart Access, sometimes it works, sometimes it doesn't. When it doesn't, it tells me to enter a parameter value, even though the field on Form_2 is populated. :banghead:
Any help would be really very appreciated! Thank you in advance!
I'm trying to set up a button to open a form (example: Form_1![Person ID]) that filter the results of the opened form based on the contents of a field [People_ID] on the form the button exists on (example: Form_2). I have the following code:
Code:
[Person ID]=[Forms]![Form_2]![People_ID]This code works, but only some of the time. It's really odd, but when I restart Access, sometimes it works, sometimes it doesn't. When it doesn't, it tells me to enter a parameter value, even though the field on Form_2 is populated. :banghead:
Any help would be really very appreciated! Thank you in advance!
