Clear Combo Box Window

  • Thread starter Thread starter Sky
  • Start date Start date
S

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?
 
Sky said:
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?
Click to expand...


Just set the combo box to Null.
 
-----Original Message-----
Sky said:
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?
Click to expand...


Just set the combo box to Null.

--
Marsh
MVP [MS Access]
.
Exactly where in the Combo Box properties do I set the
Click to expand...
Null value?
 
-----Original Message-----
Sky said:
Exactly where in the Combo Box properties do I set the
Null value?
Click to expand...

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.
 
-----Original Message-----
Sky said:
Exactly where in the Combo Box properties do I set the
Null value?
Click to expand...

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
Click to expand...
followed your instructions and it works perfectly. You
ROCK dude :-)
 
Back
Top