Access Data from a combo box
Very new to playing with Access, and the latest thing that I'm trying to figure out, is how to access data from a combo box... I'm initializing it with a query form a table...
SELECT Initiatives.Initiative, Initiatives.InitiativeName FROM Initiatives ORDER BY [Initiative];
Now, the combo box displays the initiativeName, but I want to be able to get the initiative value depending on what is selected?
Can anyone help me out?