Hi,
I'm a newbie re MS Access so my track record is not so long. But I've some track record regarding SQL and VBA code.
I've managed to succeed with getting cascaded comboxes to work in ordinary forms. But when I add these forms to a Navigation form with both horizontal and vertical tabs I don't get them to work. I've googled a lot and tried a lot of different things - unfortunately without any success. I've 'placed' my forms on the vertical tabs, if this has something to do about it?
I've read, and tried, e.g. [Forms]![NavigationForm]![NavigationSubform].[Form]![comboBox] as filter input in my query. I've also tried to add my specific form name with the combobox placed inside.
Now I've started to think if I can write some SQL string in the rawdata source in the property sheet in order to get around the challenge...
I don't want to create my own Navigationform, but I consider it strongly as well after all this frustration.
Does any kind soul have any recommendations?
I'm a newbie re MS Access so my track record is not so long. But I've some track record regarding SQL and VBA code.
I've managed to succeed with getting cascaded comboxes to work in ordinary forms. But when I add these forms to a Navigation form with both horizontal and vertical tabs I don't get them to work. I've googled a lot and tried a lot of different things - unfortunately without any success. I've 'placed' my forms on the vertical tabs, if this has something to do about it?
I've read, and tried, e.g. [Forms]![NavigationForm]![NavigationSubform].[Form]![comboBox] as filter input in my query. I've also tried to add my specific form name with the combobox placed inside.
Now I've started to think if I can write some SQL string in the rawdata source in the property sheet in order to get around the challenge...
I don't want to create my own Navigationform, but I consider it strongly as well after all this frustration.
Does any kind soul have any recommendations?