List box display

[cstanley]

Hello all,

I would like to control the output of a list box display. I would like to have a single list box that displays values from different queries, based on a button, i.e., if a button was pressed, the list box would display the values from the query that was run by the button... any idea how to code this?

Chris

 

[Jerry Stoner]

On click of each button:
Me.YourListBoxName.ControlSource = "YourqryNameHere"

 

[cstanley]

It keeps giving me an error message that the method or data member is not found . Can you help?

 

[Jerry Stoner]

Is spelling correct?
try:
Me.[YourListBoxName].ControlSource = "YourqryNameHere"

 

[cstanley]

OK - the bracketing works. But it won't update the list box display.

 

[Jerry Stoner]

Just a guess:

Me.[YourListBoxName].ControlSource = "YourqryNameHere"
Me.[YourListBoxName].Requery

 

[cstanley]

Nope Any more guesses?

 

[Jerry Stoner]

Click your button then go into design view and check the control source for your list box. Did it change to the query specified ?

 

[cstanley]

It did indeed. I tried changing the RowSource rather than the ControlSource for the list box, which worked nicely, but now, when I try to select a value, it says that my list box is bound and I can't edit the control.

*sigh*

 

[Jerry Stoner]

My Apologies

Me.[YourListBoxName].ControlSource = "YourqryNameHere

Should be:
Me.[YourListBoxName].RowSource = "YourqryNameHere

And the requery is not needed.

Sorry about that.

 

[Jerry Stoner]

Remove the control source (make it blank)

 

[cstanley]

Thanks!!! It works!!!!

Now the real kicker... I would like to have the query that I used take the value that it will filter by from a combo box on the form, thus using a combo box instead of a button (or a series of buttons, as I originally imagined) to dictate the display in the list box.

How about them apples?

Chris

 

[Jerry Stoner]

ok one query filtered by the value in a combo?

In the criteria for the query
[Forms]![YourFormName]![YourcboName]