add values to combo boxes

G

Guest

I have a combo box in a form that selects a list of composers. Id like to
have the combo box be able to accept new composers and have them bound onto
my composer table. So that in the table it shows the new composers and the
music they have written. Anyone know how to do this thanks!
 
A

AlCamp

R,
Using the Composer Combobox On Not in List event to open your Composer
entry form. (leaving your original form open)
Enter a new record for the new composer.
Close the Composer form.
Requery the Composer Combobox.
Your new Composer should be listed.
hth
Al Camp
 
G

Guest

What do i put in the On Not in List event. and how can the user tell the
computer that the composer isnt' in the list?
 

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

How to show fields from a second table 3
cant get cbo to stop outputting key# 0
Combo Box Issue 6
Controlling a list box population based on combo boxes 1
Combo Box question 4
combo box to select a table 9
Combo box - not in list 2
Why is combo box is changing values in table? 2

Top