Combo doesn't clear with a Requery

B

Bill

I'm expecting that if I move the focus away from
a combo box, after an item within it has been
selected, and issue a Requery on the combo box
that the combo box window pane will clear. Since
that's not happening, I assume I don't know enough
about what's required to "reset" a combo box to
the state it would normally be when a form opens.

What am I missing?

Thanks,
Bill
 
A

Allen Browne

Requerying the combo causes it to reload its RowSource.

If you want to clear the combo, set it to Null, e.g.:
[Combo1] = Null
 
B

Bill

Got it Allen, thanks.
Bill
Allen Browne said:
Requerying the combo causes it to reload its RowSource.

If you want to clear the combo, set it to Null, e.g.:
[Combo1] = Null

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

Bill said:
I'm expecting that if I move the focus away from
a combo box, after an item within it has been
selected, and issue a Requery on the combo box
that the combo box window pane will clear. Since
that's not happening, I assume I don't know enough
about what's required to "reset" a combo box to
the state it would normally be when a form opens.

What am I missing?
Click to expand...
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Requery combo box in subform 5
Combo box on subform not filling completely 3
Requery a form to update combo query 6
Requery a subform combo box based on a main form combo box 2
Re-setting combo boxes 8
Cascading Combos Again 1
Need combo box to refresh when moving to new record 2017 1
3 linked combo boxes in a form 2

Top