A quick question about Combo and List Boxes

[Afrosheen via AccessMonster.com]

Good morning and thanks for reading this.

I have two boxes. 1 List box and 1 Combo box.
The list box is Gender and the Combo box is for Race.

What I'd like to do is is generate a report based on either box or both.
The problem is that after the report is generated and printed the selections
of the boxes are still highlighted. What I'd like to do is I guess default
them to nothing or not have them highlighted.

Ex: Selecting male from the List box will show me all the males. And it works.

Now I want to print from the Combo box and select either all the White, Black,
or American Indian but no males. Just the race. Because the List box still
has the male highlighted I'll get all the males also when I don't want either.
And vice versa.

If I get out of the form and back in then I can select the Race and have the
report print out.

I guess my question is how do I clear out the selection so neither are
highlighted after printing?

Again thanks for the help.

 

[Alex Dybenko]

Hi,
try to set listbox to null:
me.mylistbox=null

--
Best regards,
___________
Alex Dybenko (MVP)
http://accessblog.net
http://www.PointLtd.com

 

[Afrosheen via AccessMonster.com]

Thanks Alex for getting back so fast. It worked perfectly.

Hi,
try to set listbox to null:
me.mylistbox=null

Good morning and thanks for reading this.

[quoted text clipped - 25 lines]

Again thanks for the help.