alternative to a requery

[SueM]

Hi there,

I have a form with 2 comboboxes and a control button on.
One to search for records and the other to return units
available of the item selected in combo1.

Combo1 has a requery for combo2 in it's after update event
which is working successfully, however I would like for
both combos to be able to have their contents cleared from
the on click event on a controlbutton.

In the onclick event I currently have the following:

Me.Combo1.Requery
Me.Combo2.Requery

But this isn't working. Any ideas on how I could do this
or what I have done wrong would be greatly appreciated.

Cheers,

Sue

 

[Bruce M. Thompson]

Combo1 has a requery for combo2 in it's after update event

which is working successfully, however I would like for
both combos to be able to have their contents cleared from
the on click event on a controlbutton.

In the onclick event I currently have the following:

Me.Combo1.Requery
Me.Combo2.Requery

But this isn't working. Any ideas on how I could do this
or what I have done wrong would be greatly appreciated.

Try this:

Me.Combo1.Value = Null
Me.Combo2.Value = Null

 

[SueM]

Perfect - thanks!

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

Try this:

Me.Combo1.Value = Null
Me.Combo2.Value = Null

--
Bruce M. Thompson, Microsoft Access MVP
(e-mail address removed) (See the Access FAQ at http://www.mvps.org/access)
within the newsgroups so that all might benefit.<<


.