Two Dynamic Combo Boxes

[posfog]

Hello All!
Thanks for reading first off

What i want to beable to do is have two combo boxes on a form which when i select a Zone then the second combo box only shows details assoicated with that Zone.

I have looked at this video on you tube
https://www.youtube.com/watch?v=pMiJHhjzC8Y

With that in mind i created the following
Two tables called
Zone
Issue


Within my form (called job card) created two combo boxes which pull data from the above tables
Combo boxes are called
Zonecombo (pulls data from zone table)
stationcombo (pulls data from issue table)

Both combo boxes work fine independently on the form

I then created a query with following details

Field: | Zone | Station
Table: | Issue |Issue
Sort: | |
Show: | Tick | Tick
Criteria:| [Forms]![JOB CARD]![Zonecombo] |
or: | |

(sorry for the above but i have no way of attaching a screen shot)


So i think i have followed the video to the letter (apart from names are different) but when i run the form i can not get it to work.

When i select on zone i still get the full list that is shown on the issue table.

The only thing is i am thinking on the issue table does the zone number need to be the first column as when i looked that the video the one table is showing the city then the state, so my issue table is showing the issue then the zone

Hope someone could be kind enough to help or point me in right direction

Kind Regards

 

[welshgasman]

In the AfterUpdate of the Zone combo, you need to requery the Station combo.

 

[posfog]

In the AfterUpdate of the Zone combo, you need to requery the Station combo.

Thank you so much

 

[welshgasman]

That was in the video?