Clearing a stored combobox choice from memory 1

[McLiguori]

I am using Access 2007. I have a table in which the various individuals are classified as to the 'group' to which they belong, e.g. AG = Action Group; BC = Best Chance, etc.

I am trying to use a combo box to allow the user to filter the records by the group {GR} they want to see. I created (using the wizard) a combo [Combo593] and set it to store the value for further use. The combobox draws its values from a table which lists the various groups.

In the after update property of the combobox I used the code builder and have:

Me.Filter = "GR = ???????"
Me.FilterOn = True

I have tried every thing I could think of in the place of the ?????? and nothing works. Can anyone help me with what I need to put there so that the form uses the value of the combo box to filter for the group [GR]?

Also, how can I clear the combobox's stored value, so I can make a second choice from the box and have it filter on that choice?

Thanks for any help you can give.

McLigs

 

[TheAceMan1]

How are ya McLiguori . . .

Try:

[blue]Me.Filter = "GR = '" & Me!Combo593 & "'"
Me.FilterOn = True[/blue]

To clear:

[blue]Me!Combo593 = Null[/blue]

See Ya! . . . . . .

Be sure to see thread181-473997 [blue]Worthy Reading![/blue]
Also faq181-2886 [blue]Worthy Reading![/blue]

 

[TheAceMan1]

Woops!

Should be:

[blue]Me.Filter = "GR = '" & Me!Combo593.Column(?) & "'"[/blue]

Note: column index starts at zero (0).

See Ya! . . . . . .

Be sure to see thread181-473997 [blue]Worthy Reading![/blue]
Also faq181-2886 [blue]Worthy Reading![/blue]

 

[McLiguori]

AceMan! THANKS!!! Worked perfectly!!!