Pulling data from a list box into a report

[ByronJohnson]

Hey everyone,

I don't even know if this is possible but I am trying to move data form a list box into fields in a report. The thing is that the data in the list box is not being stored anyway. It is just for display. If any one can help I would greatly appreaciate it.

Here is the code that I was trying to use withing a report open event.

Me.txtMutation = Forms!Mutations!picList.Column(0, 1)

Thanks,
Byron Johnson

 

[JoeMiller]

I don't understand what you mean by "move data." Can you explain a little more? Examples are helpful..

Joe Miller
joe.miller@flotech.net

 

[ByronJohnson]

Sorry about that.


Let me try again.

I have created this form with combo boxes. When the user selects data from the combo boxes and hits a update button information in a list box is displayed depending on what was selected. I am trying to create a report so that when the user hits a button on the form it will display the data that is in that list box in a report.

Byron Johnson

 

[JoeMiller]

Make the report record source the same as the RowSource of your listbox? You can do this in the OnOpen event of the report. Another method is build a filter based on the items in the listbox. This is slightly more difficult to do. I'm really not sure if I'm answering the question because of the vagueness, but hopefully that helps.

Joe Miller
joe.miller@flotech.net