easy listbox question

[badangel]

Hiya,

Can anyone tell me how to do this really easy thing. I want my list box to appear as empty when the form it is on is open and only display things when something is selected. I have already got it to display as I want it to, its just the getting it blank thats causing the problem. Also, its on a tabbed subform, so how do I get it to go blank every time the user goes to another tab then comes back? I have tried setting the onEnter but that doesnt work. Is it one of those bits that I ned to set?? Hope someone can help - thanks in advance!!!!

 

[Mile-O]

To make it go blank, you'll need to ditch it's RowSource.

Somewhere, in your coude where you want it to lose all values, just put:

lstYourCombo.RowSource = ""

 

[badangel]

Yeah, I worked it out. Thanks!!