DanSingleton
New member
- Local time
- Today, 05:56
- Joined
- Apr 2, 2020
- Messages
- 10
Hi all, and if you can....HELP!
I have a combobox that is auto populated based on 2 other combo boxes. I select department and team number, and it returns a filtered combobox (Combo47) with the results, which is fine.
From the resulting combobox, I want to use the value of the selected result within that box in a query. I tested the result (The combobox shows my name in it) but when I run the below code, it returns " 1 " (the ID number of the autoindexing field). If I select another person, it returns their ID field number.
Can anyone popint me in the right direction please? Further information available on request
Many thanks in advance
Dan
I have a combobox that is auto populated based on 2 other combo boxes. I select department and team number, and it returns a filtered combobox (Combo47) with the results, which is fine.
From the resulting combobox, I want to use the value of the selected result within that box in a query. I tested the result (The combobox shows my name in it) but when I run the below code, it returns " 1 " (the ID number of the autoindexing field). If I select another person, it returns their ID field number.
Can anyone popint me in the right direction please? Further information available on request
Code:
Dim getnm As String
getnm = Me.Combo47.Value
MsgBox getnm
Many thanks in advance
Dan