Search results

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...

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.

I have tried that, and I get a Compiler error, Object Required with the Sub highlighted and the variable temp_jobID highlighted. Private Sub btn_Review_Click() Dim temp_jobID As String Set temp_jobID = Me.ls_JobsToCommitInfo.Column(0, ls_JobsToCommitInfo.ItemsSelected)...

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...

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...