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
665
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

Is there a shortcut key for strikethrough?
Ctrl+S is used for Save. Ctrl+5 is used for Strikethrough. Why Ctrl+5? When you use hashmarks to count |||| is 4, strike through to mean 5.

Watch MrExcel Video

Forum statistics

Threads
1,099,679
Messages
5,470,095
Members
406,681
Latest member
sachinmasurkar

This Week's Hot Topics

Top