Hello everyone,

My problem is updating Subform filter by onchange event in one of
main form field

I've got following:

Me![NOTAWY Podformularz].Form.Filter = "[zamkniecie] = "" N ""
OR ([zamkniecie] = ""T"" AND notanr = " & Me!nrnoty & ")"
Forms!frmNOTAWY.Form![NOTAWY Podformularz].Requery


Is Change right event for that?

Thank you in advance!

Maciej

Hi Macie

OnChange may not be best as it triggers off too regularly. It's probably
best using the BeforeUpdate Event.

Dom

<maciejfr (AT) poczta (DOT) onet.pl> wrote

Dominic Vella wrote:

I suppose OnChange would be useful if the developer desired the form be
filtered everytime a key is pressed. Personally, I prefer the
AfterUpdate event because the BeforeUpdate event may have error
validation checks and could be canceled.

I really don't see why Macie needs to requery the form when a new filter
is applied. Making a new filter should be sufficient. If the filteron
property in on, the form will be requeried 2 times. The code I usually
use to filter looks something like this
Dim strF as String
If Not Isnull(Me.Status) then
strF = "Status = '" & Me.Status & "'"
Endif
Me.Filter = strF
Me.FilterOn = (strF > "")

Carolina
http://www.youtube.com/watch?v=wxMHn5oYJq4