Annoying Datasheet Form Problem

[music_al]

I wont even try to explain this problem...

If you open the Shopping List form you will see what I mean when you click in the Food Sub Type column


Thanks

Allan

 

[HiTechCoach]

You are trying to use cascading combos boxes. You will have this issue not only with datasheet mode, but also with continuous forms. It has been this way for a long time in Access.


Check out this page by AWF member LPurvis: Downloads (click here)
Look for Continuous Form Combo

See if that helps ...

 

[music_al]

Thanks for that Boyd but I dont see how the example database shows a solution to my problem. Or am I missing something ?

Al

 

[HiTechCoach]

The example handles exactly what you need, but I think it only works with continuous mode.

AFAIK, you will not be able to use datasheet mode. You will need to switch to continuous mode. I almost never use datasheet mode. It just has to many limits.

 

[music_al]

Sorry but it must be me being stupid. The example at the link you sent me doesnt seem to work. Shoul I expect the Service Combo to change when the Category Combo changes? It only changes if you force a refresh.

 

[HiTechCoach]

Last time I ran it, it appeared to be working just fine. I will take a look at it and get back to you.