Question listbox help

[jaz1976]

Hey,

I need help with a listbox. I have a listbox that is populated with data from a table. I would like to use one of the columns data as the where clause of a sql string that will populate another form, how do I get the selected items column data that I need into a variable? This is in Access 2010 vba.

 

[pr2-eugin]

Try this..

yourVariable = Me.ListBoxName.Column(columnNumber, ListBoxName.ItemsSelected)

Listbox columns are zero based which means if you want data from 1st column you will use 0 not 1..

 

[jaz1976]

Ok, your code seems to work fine. I am getting the right data from the selected items column, but I don't know what I'm doing wrong with my code.

Private Sub btn_Review_Click()
    Dim temp_jobID As Control
    
    Set temp_jobID = Me.ls_JobsToCommitInfo.Column(0, ls_JobsToCommitInfo.ItemsSelected)
    Debug.Print temp_jobID
End Sub

I am getting "Object Required on the Set line. I need to be able to set this to something I can use. I tried to set is as a string as well.

 

[jdraw]

TRY:
Change
Dim temp_jobID As Control
to
Dim temp_jobID As String

 

[pr2-eugin]

Why have you declared temp_jobID as control??

 

[jaz1976]

I have tried that, and I get a Compiler error, Object Required with the Sub highlighted and the variable temp_jobID highlighted.

[highlight]Private Sub btn_Review_Click()[/highlight]
    Dim temp_jobID As String
    
    Set [highlight][COLOR=RoyalBlue]temp_jobID[/COLOR][/highlight] = Me.ls_JobsToCommitInfo.Column(0, ls_JobsToCommitInfo.ItemsSelected)
    Debug.Print temp_jobID
End Sub

 

[pr2-eugin]

Okay, I am not sure why you had it declared as Control.. and String does not need the Set keyword.. just

temp_jobID = .....

 

[jaz1976]

Sorry about that, I didn't see that I had the set keyword on the variable when I had it defined as a string. It is working now. Thanks for the help.

 

[jaz1976]

Thanks for the help everyone. Now that I got the data that I want from the selected row, I have put it into a hidden textbox. How do I pass that to another form in the DoCmd.OpenForm. This other form needs to be populated with the data of the record selected in the last form, so the user can review the data before committing it to the database.

 

[jdraw]

Did you look at the OpenArgs of the form? It may do what you need.
http://msdn.microsoft.com/en-us/library/office/ff836583.aspx