open report from combo

[antonyx]

Seasons Greetings to all.. I hope you didnt put on too much weight.

The fog at Heathrow ensured I had a very stressful Christmas.. but thankfully it has gone for now.

i have a question regarding choosing a report to open based on a combo list..

i have a field called jobtype..

this field will always have either
"CASH" or "ACCT"

i have 3 separate report designs.. 1 design for cash jobs, 1 design for acct jobs, and 1 deisgn for both jobs.

i want a form that will allow my user to choose which report to look at..

lets call it form1.. i want to place a combo on my form (combo1) that has the values..

CASH
ACCT
BOTH

i realise that in my report query source.. i can use the following as the jobtype criteria

[Forms]![form1]![combo1]..

Question

I need the combo to realise that if the CASH value is selected.. it should open the CASH report..

if the ACCT value is selected.. it should open the ACCOUNT report..

and finally if BOTH is selected then open the BOTH report..

how can i do this?

 

[boblarson]

In the AfterUpdate event of the combo box, put:

Select Case Me.YourComboBoxNameHere

Case "Cash"
   DoCmd.OpenReport "YourCashReportNameHere", acPreview

Case "Acct"
   DoCmd.OpenReport "YourAcctReportNameHere", acPreview
Case "Both"
    DoCmd.OpenReport "YourCashReportNameHere", acPreview
    DoCmd.OpenReport "YourAcctReportNameHere", acPreview
End Select

This will work if your bound field in your combo box is the field that returns the text. If not, change the Select Case YourComboBoxName to
Select Case YourComboBoxName.Columns(1) or whatever number (minus 1) is the actual column with the appropriate text.

 

[antonyx]

you legend.. let me give it a go..

 

[antonyx]

yeah its working.. thank you bob

 

[antonyx]

ok i had it working but im gettin a small error Run-time '3211': now and ive tried changing the locks of the form but it is still there..

im sure its something very minor.. can you see why this is happening??

 

[ansentry]

Have a look at the attached sample. I have sent you the 2000 version if you require 97 post back.

 

[antonyx]

im beginning to realise that tables are the pond and forms are the fishing rods and queries are the bait

 

[antonyx]

and records are the fishes