MS ACCESS: Open form from combo box selection

[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?)

[ToxXxic]

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:

 
Private Sub cmbobox1_AfterUpdate()
Forms![form1].FilterOn = True
Forms![form1].Filter = cmbobox1
MsgBox cmbobox1
End Sub

[ToxXxic]

Please note that if the user types a value in the combo box then they will have to press the enter key or move to another field on the form in order for the "AfterUpdate" event to fire

[Notorios]

I tried what you said with doubts in mind and it didn't work . I don't think the event is firing because i have a message box in there as the first thing and that doesn't pop when I click a member of the list.
So the question is why is the event not firing?

[ToxXxic]

I tried what you said with doubts in mind and it didn't work . I don't think the event is firing because i have a message box in there as the first thing and that doesn't pop when I click a member of the list.
So the question is why is the event not firing?

PM me with your email address and I will send you a sample database to show you that it works

Also if possible: send me a sample of the entire code on the form

[ToxXxic]

Did you rename the combo box? If you did then check to ensure that the combo box name is consistent with the name of the AfterUpdate event.

[Notorios]

Tried what you sent toxxxic, yours ran fine, copied it to my db and it ran fine in there, compared and made changes still didn't work. Made a new one in another form and it worked, recreated in the original form, did not work. So i figure something must be wrong with that form so i think i will recreate that form and see what happens, nothing much on it anyway.

[Notorios]

Decided to snoop around the form, found my problem, the form had the Property Allow Edits set to No, changed it to yes and smooth sailing. Thanks for the help.