Question Selecting report from Combox values?

[UnrealEnvy]

Hello, I was wondering how can I make a Combo box, in which I will type, for example:
Financial report

and by selecting it, I will get that specific report opening.
Same goes for more values, and reports that matches.

There's an example of exactly what I want in Marketing Projects in Access 2007 - They choose the reports in a combo box exactly as I would like to.

Just how do I do it?

Thanks for the help.

 

[pbaldy]

Presuming the combo has actual report names:

DoCmd.OpenReport Me.ComboName...

 

[UnrealEnvy]

Presuming the combo has actual report names:

DoCmd.OpenReport Me.ComboName...

Thank you, but I still need a little bit more on where to type that in, I'm pretty new in Access, and would appreciate if someone could explain to me if that's all the commands I need, and where do I type it?

Thanks,
Tal.

 

[pbaldy]

Access is very event driven. You would put that in the event that best matches how you want the program to operate. Most would probably have a button the user would click on, some would use the after update event of the combo.

 

[UnrealEnvy]

Access is very event driven. You would put that in the event that best matches how you want the program to operate. Most would probably have a button the user would click on, some would use the after update event of the combo.

Yeah, I've seen the "after update", and I can create a macro that will open the report.
Thing is, I don't know how to do that. I mean, what do I write in the condition? How do I tell the macro, that If the value is Finance report Then open finance report?

 

[pbaldy]

I'm not sure it can be done in a macro, as I don't use them. I would use the VBA code above.

 

[UnrealEnvy]

I'm not sure it can be done in a macro, as I don't use them. I would use the VBA code above.

Unfortunately, I don't know VB at all. I've seen that Microsoft Database called "Marketing" in Access 2007 is doing that with a macro.
Thing is, I really don't understand what they did there, and so I cannot do the same for myself.

Anyone can help out please?