Clear Combo Box Window

[Sky]

I have a Combo Box that runs queries for Anniversaries. Is
it possible to clear the Combo Box window after the query
is run. What happens is after the query runs, the query
file name remains in the Combo Box window.

For example if I run a query whose file name is "January
Anniversary", then "January Anniversary" remains in the
Combo Box window. Is there a way to keep the window blank
after the query is run?

 

[Marshall Barton]

I have a Combo Box that runs queries for Anniversaries. Is
it possible to clear the Combo Box window after the query
is run. What happens is after the query runs, the query
file name remains in the Combo Box window.

For example if I run a query whose file name is "January
Anniversary", then "January Anniversary" remains in the
Combo Box window. Is there a way to keep the window blank
after the query is run?

Just set the combo box to Null.

 

[Sky]

-----Original Message-----

I have a Combo Box that runs queries for Anniversaries. Is
it possible to clear the Combo Box window after the query
is run. What happens is after the query runs, the query
file name remains in the Combo Box window.

For example if I run a query whose file name is "January
Anniversary", then "January Anniversary" remains in the
Combo Box window. Is there a way to keep the window blank
after the query is run?

Just set the combo box to Null.

--
Marsh
MVP [MS Access]
.
Exactly where in the Combo Box properties do I set the

Null value?

 

[Marshall Barton]

-----Original Message-----

Exactly where in the Combo Box properties do I set the
Null value?

Well, it's the Value property, but you have to use code in
an event procedure to set it. You never said how you're
"running" the query, but I presume it is done by some code
in some event. Just add
Me.thecombobox = Null
after whatever code runs the query.

 

[Sky]

-----Original Message-----

Exactly where in the Combo Box properties do I set the
Null value?

Well, it's the Value property, but you have to use code in
an event procedure to set it. You never said how you're
"running" the query, but I presume it is done by some code
in some event. Just add
Me.thecombobox = Null
after whatever code runs the query.

--
Marsh
MVP [MS Access]
.
Thanks a million times over Marshall for your help. I

followed your instructions and it works perfectly. You
ROCK dude