Originally Posted by
Notorios
Yet another access question from me.
So I have a combo box on a form that i want to use to open another form and filter that form with the value in the combo box. The combo is not bound to any table i just let it select the values from a query, it also has two fields in it.
I tried using the "after_update" event but that doesn't work i guess because when i click something in the combo box, it is not selected, the list just stays open. The list is enabled and not locked.
Anyone know what I am doing wrong?
(I'm guessing its because its not bound?)
The after_update is fired However you need to set the form filter property to true. For example:
Code:
Private Sub cmbobox1_AfterUpdate()
Forms![form1].FilterOn = True
Forms![form1].Filter = cmbobox1
MsgBox cmbobox1
End Sub
Last edited by ToxXxic; Aug 13, 2009 at 04:31 PM.
Code King aka Code WizZzard: Motivated By The Challenge, Driven By The Will To Succeed.
In The Land Of Programmers, The Code WizZzard Is KING. Sen on anything VB