stardustvega
Member
- Local time
- Yesterday, 22:44
- Joined
- Feb 4, 2022
- Messages
- 36
I am basically trying to create my own wizard using an Access form. On the first step, the user needs to make a choice between two types of events. Because this is a wizard, I don't want to store the value they choose in my database, but I *do* need to use the choice to call something else.
I am currently trying to do this with an unbound listbox. The listbox has two columns with one hidden (width = 0").
The listbox's name is EventTypeSelector.
This is my current code, which I want to run when a button is clicked.
When I run this, I get an "Invalid use of null" error.
I have also tried this variation:
That results in an "Wrong number of arguments or invalid property assignment" error.
(If this is a bad way to go about my end goal, I would welcome alternative suggestions too.)
I am currently trying to do this with an unbound listbox. The listbox has two columns with one hidden (width = 0").
The listbox's name is EventTypeSelector.
This is my current code, which I want to run when a button is clicked.
Code:
Private Sub BtnChooseEventType_Click()
test = Me.EventTypeSelector.Column(0)
MsgBox (test)
End Sub
When I run this, I get an "Invalid use of null" error.
I have also tried this variation:
Code:
Private Sub BtnChooseEventType_Click()
test = Me!EventTypeSelector.ItemsSelected
MsgBox (test)
End Sub
That results in an "Wrong number of arguments or invalid property assignment" error.
(If this is a bad way to go about my end goal, I would welcome alternative suggestions too.)