Solved cascading context menu in form

[alvingenius]

Hello
I have seen a couple of posts on this forum about shortcut menus and context menus and I wanna make it deeper

I have a form with 3 cascading combo boxes, getting data from 3 tables, with a one to many relationships between them

so, I wanna just create a button when I click it opens a context menu from 3 levels, every level handles a table! the same way cascading combo box work

and also after choosing the level 3 menu, I need to save every chosen record on textboxes as the screenshot shows!

Is that possible?
I'm attaching the example DB if you wanna test on it.

 

[isladogs]

Easy to do using cascading combos. See

Cascading Combo Boxes

This explains how cascading combo boxes are used to filter large datasets in Access

www.isladogs.co.uk

 

[theDBguy]

Check out this other thread.

Solved - Can i make a shortcut menu with levels ?

This idea works so well, not sure why everyone has not been doing more of this. And this is just scratching the surface. You can add all types of menu items. The code is actually rather easy and would work on any database, you just have to build the queries. I loaded a large database with lots...

www.access-programmers.co.uk

 

[alvingenius]

Easy to do using cascading combos. See

Cascading Combo Boxes

This explains how cascading combo boxes are used to filter large datasets in Access

www.isladogs.co.uk

Thanks @isladogs for your reply
i've already done it with cascading combos, but I wanted to make it as context menu

 

[MajP]

Thanks @isladogs for your reply
i've already done it with cascading combos, but I wanted to make it as context menu

The answer is "Yes". See my example.

Solved - Can i make a shortcut menu with levels ?

Hello guys , I can do a standard shortcut menu with commandbars method but can i make a shortcut with levels like windows using VBA ? Thanks in Advance .

www.access-programmers.co.uk

 

[theDBguy]

Thanks @isladogs for your reply
i've already done it with cascading combos, but I wanted to make it as context menu

@alvingenius Did you miss my post?

 

[theDBguy]

The answer is "Yes". See my example.

Solved - Can i make a shortcut menu with levels ?

Hello guys , I can do a standard shortcut menu with commandbars method but can i make a shortcut with levels like windows using VBA ? Thanks in Advance .

www.access-programmers.co.uk

@MajP Great minds think alike...

 

[MajP]

A Better Solution to Cascading Comboxes?

A few questions have come up about Command Bars recently. https://www.access-programmers.co.uk/forums/threads/can-i-make-a-shortcut-menu-with-levels.321868/ https://www.access-programmers.co.uk/forums/threads/cascading-context-menu-in-form.322059/ I use this idea pretty frequently because I...

www.access-programmers.co.uk

 

[alvingenius]

Check out this other thread.

Solved - Can i make a shortcut menu with levels ?

This idea works so well, not sure why everyone has not been doing more of this. And this is just scratching the surface. You can add all types of menu items. The code is actually rather easy and would work on any database, you just have to build the queries. I loaded a large database with lots...

www.access-programmers.co.uk

@alvingenius Did you miss my post?

Sorry for the delay, I had a situation that prevented me to open the forum since I post it
So, like I said I've seen a couple of posts regarding shortcut menus, ur mentioned link is one of them ! and it didn't help me since it's going with the 3 tables levels! the same as my example of cascade combo box

 

[alvingenius]

A Better Solution to Cascading Comboxes?

A few questions have come up about Command Bars recently. https://www.access-programmers.co.uk/forums/threads/can-i-make-a-shortcut-menu-with-levels.321868/ https://www.access-programmers.co.uk/forums/threads/cascading-context-menu-in-form.322059/ I use this idea pretty frequently because I...

www.access-programmers.co.uk

that's exactly what i was looking for
thanks @MajP