Solved cascading context menu in form (1 Viewer)

alvingenius

IT Specialist
Local time
Today, 04:56
Joined
Jul 10, 2016
Messages
168
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: 156

isladogs

CID VIP
Local time
Today, 03:56
Joined
Jan 14, 2017
Messages
16,382
Easy to do using cascading combos. See
 

theDBguy

I’m here to help
Staff member
Local time
Yesterday, 19:56
Joined
Oct 29, 2018
Messages
19,154
Check out this other thread.

 

MajP

You've got your good things, and you've got mine.
Local time
Yesterday, 22:56
Joined
May 21, 2018
Messages
6,430
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
Yesterday, 22:56
Joined
May 21, 2018
Messages
6,430
 

alvingenius

IT Specialist
Local time
Today, 04:56
Joined
Jul 10, 2016
Messages
168
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, 04:56
Joined
Jul 10, 2016
Messages
168
that's exactly what i was looking for
thanks @MajP
 

Users who are viewing this thread

Top Bottom