Cascading combo: a different kind of challenge

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am not too sure where to put this query so I thought programming might be
the best.

I understand combo boxes ok but I want to use the combination of the two
options to open a specific report. Eg: if I choose "weekly total hours" and
then "administration", I can open the information I want for that department.

I am now approaching 20 buttons so I thought there might be something a bit
less redundant I can use.

Cheers in advance.
 
I've done it

If Forms.chart1.Info = "FTE" And Forms.chart1.Dept = "Administration" Then
stDocName = "FTE - Administration"
DoCmd.OpenReport stDocName, acPreview

End If
 
Back
Top