By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,968 Members | 1,661 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,968 IT Pros & Developers. It's quick & easy.

update subform filter by onchange event on main form

P: n/a
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
Feb 28 '08 #1
Share this Question
Share on Google+
1 Reply


P: n/a
Hi Macie

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

Dom

<ma******@poczta.onet.plwrote in message
news:f7**********************************@c33g2000 hsd.googlegroups.com...
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

Feb 28 '08 #2

This discussion thread is closed

Replies have been disabled for this discussion.