Can I update what a cbo box's row source is after it has been loaded in the form.
Posted on 2009-03-31
I have a cbo box on my form and it is being controlled by a qry that pulls certain items out of a table. The user has to select one of the items from the list. However the item may not be in the table, so I have a button that they can press and a new form opens and they can add it to the table. When you do this, It is not able to be selected in the cbo box. If you close the form and reopen it, it is then available. I would like it to be available without exiting the form. I am hoping that this is possible and fairly easy.
Thanks for your help.