[MSAccessProfessionals] sql list

Hi

What I'm trying to achieve here one menu set of buttons control the outcome of a list;

 

The user selects from the main menu (1)

Which place the number one in this case into the text box (2)

The user then clicks the hamburger icon (3) in which the category list appears sorted out by query

The list box should only show a category list as shown (5). But unfortunately the list turns up blank, or without the selection condition shows all.

 

The VBA

   SQLText = " SELECT [dbtMenuSubList1].[Menlistid],[dbtMenuSubList1].[MListName] " _

       & " FROM [dbtMenuSubList1],WHERE [dbtMenuSubList1].[Menlistid]= 1; "

Me.ListSubMenu.RowSource = SQLText

Could I please if you could tell how to achieve the above , and point out what I did wrong (office 365 64bit)

_._,_._,_

---

Groups.io Links:

You receive all messages sent to this group.

View/Reply Online (#116457) | Reply To Group | Reply To Sender | Mute This Topic | New Topic
Your Subscription | Contact Group Owner | Unsubscribe [sugeng.panjalu.access@blogger.com]

_._,_._,_