combo box problem

[mitch97144]

I have a combo box on form which displays three game types (1-Divisional Trophy 2-League Cup 3-League). What i need to do is based upon the selection of 1&2 i want it to allow access to another combo box. The other combo box will display a list of rounds qtr,semi-final etc. However the list of rounds is different for both 1&2.

i.e

If 1 selected in combo1 then display prelim,R1,R2,R3,QTR,SEMI,FINAL within combo2

If 2 selected in combo 2 then display R1,R2,R3,R4,QTR,SEMI,FINAL

Once the value from the second combo box has been selected it must update a field within a table.

Can anyone advise on how to do this.

 

[MStef]

Hello mitch97144!
Look at "DemoGameTypesA97.mdb"
I think it is what you need.
(MStef alias Štef)

 

[MStef]

I'm sorry, there was an error in VBA,
here is a new verison.