Using vba to open a Report based on a Field Value

[spectrolab]

Hi Guys,

This might be pretty simple, but what I am trying to do is to write some code attached to a form that will open one of 3 or 4 different reports (different formats) depending on a value in a query. For example, you select a particular value from a combo box and it runs a query to check what the value is that determines the report to open and then opens it?

Any ideas?

 

[Dennisk]

easy, use the query as the select statement for a recordset, then you can access the calculated value and possibly use a case statement to determine what report to open.