Setup Combo Box (with 3 fields) - Assistance with why it won't sort my Form Items Correctly

squeakums

Well-known Member
Joined
May 15, 2007
Messages
677
I have a Combo Box with (3) Fields:

SELECT [GP Schedule].[EVM/VM], [GP Schedule].BEID, [GP Schedule].BusinessEntityName
FROM [GP Schedule]
WHERE ((([GP Schedule].[EVM/VM]) Is Not Null))
ORDER BY [GP Schedule].[EVM/VM];


I have it setup and bound to Column 2 - which is the BEID. When I select the items it won't change on my form. If I setup the combo box bound to column 1, it filters only by the EVM Name and not by the EVM and by the BE ID so that is why I was only trying to set it up to filter by BEID in my form. Any suggestions please?
 

Some videos you may like

Excel Facts

Ambidextrous Undo
Undo last command with Ctrl+Z or Alt+Backspace. If you use the Undo icon in the QAT, open the drop-down arrow to undo up to 100 steps.

Watch MrExcel Video

Forum statistics

Threads
1,102,291
Messages
5,485,973
Members
407,523
Latest member
Talicius

This Week's Hot Topics

Top