Refresh Combo Box - Unbound Form

S

ScottS

Hello all

I have an unbound form with 2 combo boxes and a list box. As users are
entering or processing records the contents of the combo boxes and list box
need to reflect changes to their respective row sources.

I have used recalc, requery, repaint, refresh in my code but am getting
inconsistent results. I have applied these methods to the individual
controls and form, but since I am not getting the results I need I can only
conclude that I am not using them correctly.

What is the best practice to ensure that these controls refresh properly
when directed?

Thanks in advance for your help.
 
D

Douglas J. Steele

Requery should be the appropriate one. You need Me!NameOfControl.Requery.
 

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

Top