Solved cascading context menu in form (1 Viewer)

alvingenius

IT Specialist
Local time
Today, 15:38
Joined
Jul 10, 2016
Messages
169
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
1645817865177.png


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.
 

Attachments

  • cascade combobox-example.accdb
    532 KB · Views: 246

isladogs

MVP / VIP
Local time
Today, 13:38
Joined
Jan 14, 2017
Messages
18,186
Easy to do using cascading combos. See
 

theDBguy

I’m here to help
Staff member
Local time
Today, 06:38
Joined
Oct 29, 2018
Messages
21,358
Check out this other thread.

 

MajP

You've got your good things, and you've got mine.
Local time
Today, 09:38
Joined
May 21, 2018
Messages
8,463
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.
 

MajP

You've got your good things, and you've got mine.
Local time
Today, 09:38
Joined
May 21, 2018
Messages
8,463
 

alvingenius

IT Specialist
Local time
Today, 15:38
Joined
Jul 10, 2016
Messages
169
Check out this other thread.


@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

IT Specialist
Local time
Today, 15:38
Joined
Jul 10, 2016
Messages
169
that's exactly what i was looking for
thanks @MajP
 

Users who are viewing this thread

Top Bottom