combo controls in vba

[andyhutch119]

Is there anyway to initialise a combo box in Access vba. I need to have a clear list before populating it from a recordset. I've tried to loop through using the removeitem but this is causing problems as the indexs don't always match and causes errors.

 

[PHV]

And what about something like this ?
Me![combo name].RowSource = ""

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[TimTDP]

You could use combobox = ""
You should also be able to simply populate it by setting the Control Source / Row source at run time
Requery the combo box after populating it