Opening Query after combobox selection

[amona]

Hi,

I am trying to run query after selecting from cobmbobox list.
I did the following but no luck:
rivate Sub Comb_AfterUpdate()
DoCmd.OpenQuery "Function"
End Sub

And wrote in the criteria
[Forms]![Printer Or Scanner]![Comb]
Function is the query, Printer Or Scanner -- the form.
Could anyone help, please?

 

[pbaldy]

What does "no luck" mean? The code looks fine (though I never let users into tables or queries).

 

[amona]

Thanks for the replay.
I am really new to Access… Sorry
I want to run the query from a form after selecting from combobox.
My code is not working
“though I never let users into tables or queries”
Then, what should I do?

 

[Padwan]

This may be off, but isn't it possible to create combo box with query titles listed in it to select rather than writing code?

 

[amona]

How can I do this?
I am a beginner...

 

[amona]

Could anyone check my code and help to fix it, please?

 

[JANR]

Nothing wrong with your code it works as intended, have you enabled codes/macros?

http://www.btabdevelopment.com/ts/default.aspx?PageId=13

JR

 

[amona]

Thanks a lot