alternative to a requery

  • Thread starter Thread starter SueM
  • Start date Start date
S

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
 
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.
Click to expand...

Try this:

Me.Combo1.Value = Null
Me.Combo2.Value = Null
 
Back
Top