Combo Boxes

R

R

I have a combo box that lists composers. If the user hits the arrow and
looks and the composer and finds out that composer isn't it there they don't
have to pick one and then click a second button, addnewcomposer. A form
opens and they can add a new composer and then exit out of it. Now when they
go back into the combo box and hit the arrow that composer isn't listed..Is
there anyway i can "refresh" the combo box after adding a new composer.
Thanks!
 
R

R

Thanks for the reply
Ok I put that in my close button exit code i just typed it right in..I went
to do it and it still hadn't refreshed it..should i put that exit code in the
whole form itself or just in the button and if so what am i doing wrong??
Thanks a million!
 
R

R

Roger-
I put it in the whole from on close and it worked!! You Are The Man!!!
Thanks a Million....I owe you something THank you!!
 
R

Roger Carlson

Let me make certain you understood me. The example I gave was with made up
names, which you have to substitute YOUR form and query names. (Pardon me
if you've already done that. I'm just making sure.) If you're not certain
what I mean, please list what you actually typed.

The code could be either in the button that closes the AddComposer form OR
you could put it in UnLoad event of the form. The latter is preferred
because it will fire regardless of how the form is closed.

--
--Roger Carlson
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L
 
Top