Stupid Cascading Comboboxes (1 Viewer)

[basshead22]

Hello all ! happy new year!

I've been trying to create a cascading combo box for a few weeks now and I get the same darn problem...

The selection on my (unbound) first combo dictates what u see in my (Bound) second combo... my problem is what ever I choose on my first combo it defaults to the new record and if I change it on the new record it changes it on my previous record.

I've taken some screenshots so you guys can get a little better idea.

First pic my two combos with the first one already defaulting to the new record
Second pic the properties for my first combo
Third Pic the query for my second combo

 

[spikepl]

http://www.access-programmers.co.uk/forums/showpost.php?p=1319039&postcount=2

 

[basshead22]

Thanks a mill spikepl took me awhile to follow Pats instructions but it works great!! Man what would I do without this forum!!!

HAPPY NEW YEAR!