Print Value of Access Dropdown

[Geodon7]

This is a very simple question, but I don't know VB well enough to know how to do it. I have a dropdown box, and I want to know what the value of it is being stored as so I can know if I am referring to it correctly at a later point in my code. This is the code I have:

Dim test As String
    test = ProgramNameDrop.Value
    Debug.Print test

My problem is I don't know how to output code to a window where I can see the value. Additionally, I don't know where to place this code within my VB file. I also do not know if I have coded this correctly.

Thanks for helping out a beginner!
G

 

[zemp]

If I understand you correctly you want to be able to see the selected value from the combo box named ProgramNameDrop.

Dim test As String
test = ProgramNameDrop.text
msgbox test

This places the selected value into your variable and then displays it with a message box. To display it in a text box use,
Text1 = ProgramNameDrop.text Thanks and Good Luck!

zemp

 

[robctech]

I'm not sure what it is you want but if in your dropdown box you are displaying text and assigning an alternat value such as the display says ITEM1 but the value of that when selected is 1 then you need to use

test = ProgramNameDrop.ItemData(ProgramNameDrop.ListIndex)

this will give you the the value of the currently selected item, additionally you can use

msgbox = text

to display the value in a msgbox window

Hope this helps ... good luck

 

[zemp]

robctech is correct in the alternative method of assigning the value to a variable , but watch the message box funtion.
It should read

msgbox test
Thanks and Good Luck!

zemp

 

[robctech]

ooops...hey its monday give me a break....LOL