dropdown menu from data query

Getting Started
1

Simple task in any programming language… I’d like an example of populating or building a menu popup or dropdown using the return data record set from a unique query of a data table. E.g. if the recordset contains 10 items, loop through the record set adding a menu item to the list from the recordset. Then, as
and example, popup the selected item from the list/menu via msgBox().

2

Presuming you already have a RecordSet with data, just iterate through it and add the rows to the PopupMenu

While Not myRecordSet.EOF myPopupMenu.AddRow(myRecordSet.Field("ColumnName").StringValue) myRecordSet.MoveNext Wend

Then in the Change event handler of the PopupMenu, display the selected text:

MsgBox(Me.Text)
3

Thanks