Filter a Form by Switchboard Item

ranen

pinoy 'to
Local time
Today, 04:08
Joined
Jun 14, 2005
Messages
29
:( I am using a switchboard in my database, I have 3 forms using the same query,formats,etc but the 2 of 3 have filters. My question is how can I filter the form when I click a button in the Switchboard.

I tried to do
docmd.applyfilter
but when the form is open nothing happens.

And I also use the Form_Switchboard!Itemnumber = 2 but the only number it can see is with 0 value.

Please help me. I just don't know how to catch the field from Switchboard. Please help. Thank you so much.
 
Tried

I tried to filter on the form open's event but I cannot get the right field that I will filter coming from the Switchboard.

Thank you for the respond.:)
 

Users who are viewing this thread

Back
Top Bottom