Navigation Alt Key ampersand problem - Sub form

[Zlightbulb80]

Hello.



I have written a simple database with two tables A & B, which generates two queries A & B and I have two continuous forms A & B, which each view their respective query results.

I have a single It navigation form which has two tabs, one to subform A and one to subform B.

It all works fine, I am able to add, delete, duplicate records and switch between the two forms via the navigation menu, when I click with the mouse any of the tabs.

I have set up ampersands ahead of the button captions to allow me to Alt + instead of using the mouse.

However, when I use the any Alt key combination, the navigation form disappears (the tabs disappear) and I'm left stuck in the current sub form (A or B) and have to manually close, then re-open the navigation form and start over...

Can anyone help??

Thanks

Brad

[Micron]

You've used a key combination that is already taken? Not sure because this isn't clear

the any Alt key combination

Maybe repeating the keypress would return the nav form? Have to say I've managed to avoid nav forms so far, so my experience with them is limited.
For what it's worth, it's extra overhead to have multiple versions of the same form just because you want to base it on different queries. I'd rather alter the form recordsource depending on user interaction, or if it's a simpler matter, just filter it. At least that's my preference. Suppose you have to add something to the form? You have to do it for each, and if you're using macros, maybe you need 2, which might require them both to be altered as well. Maybe you can see the point...

[CJ_London]

cross posted here

https://www.access-programmers.co.uk...d.php?t=299163

OP advised on other thread to usual link