Continuous Form Issue with comboboxes

[chrisjames25]

I have a continuous form with all of the comboboes and textboxes bound to a field in a table.

I have a combobox for choosing the category and when i choose the category it filters down my options in my variety combobox to only those within that category.

Works fine. If i change the category i have an afterupdate event that removes the variety entry.

me.cbo_variety.requery
me.cbo_variety

This works fine when not on continuous forms but now using them if i use this code it deltes the variety form all the entries above the current entry.

No idea why this is happening. How do you make it so it only alters the current record?

Cheers in advance

 

[Ranman256]

The .requery is all you need.
You don't need the 2nd line.

If the cbo is unbound, all entries on continuous form will match.

 

[CJ_London]

I think your are talking about cascading combo's

the values are still there but because you are changing the combo filter, if the value is not one that is included in the filter then nothing is displayed.

See this link to see how to get round the problem

https://www.access-programmers.co.uk/forums/showthread.php?t=275155&highlight=cascading+combo

 

[chrisjames25]

Hi CJ. THanks very much. That helped alot and now allows me to do what i wanted to achieve.

 

[preethishetty]

Hai,
The actual time and effort took to create this wonderful article were really great and would like to read this blog regularly to get more important stuff.