H
hydroparadise via AccessMonster.com
For some reason the filter is is removed once the form has been requeried or
"refreshed" (F5). Is there an event thats triggered associated to requerying
so I might to try to reverse this action or is there a way to keep this
happening all together. I am using the DoCmd.OpenForm method to open and
filter the form base on a record that is currently open. Heres the code
DoCmd.OpenForm "BidTakeOffDetails", acNormal, , "TakeOffID = " Me.
TakeOffItemID.Value, acFormEdit, acWindowNormal
A side problem with using adp is that unless I provide someway to clearing
Form.Filter and Form.ServerFilter, those properties are saved to the first
occurance of the filter. From that point on, no matter whats used to filter
the form, it continues to filter what what was filtered previouly. Seems
like this was different using Jet/Ace. Is this normal with adp?
"refreshed" (F5). Is there an event thats triggered associated to requerying
so I might to try to reverse this action or is there a way to keep this
happening all together. I am using the DoCmd.OpenForm method to open and
filter the form base on a record that is currently open. Heres the code
DoCmd.OpenForm "BidTakeOffDetails", acNormal, , "TakeOffID = " Me.
TakeOffItemID.Value, acFormEdit, acWindowNormal
A side problem with using adp is that unless I provide someway to clearing
Form.Filter and Form.ServerFilter, those properties are saved to the first
occurance of the filter. From that point on, no matter whats used to filter
the form, it continues to filter what what was filtered previouly. Seems
like this was different using Jet/Ace. Is this normal with adp?