Combo box in sub-form

C

Chris

To John W Vinson:
Any chance of an answer to my previous question, as follows? I really would
appreciate your help; you're my last hope!
The Track Artist table is not needed then. Just put a TrackArtistID field in
the Tracks table (so you can enter just one ID for that track).

You will not be able to type new names into a combo box with your current
structure; what you'll need is some code in the combo box's NotInList event to
pop up an Artists form when a new entry is needed.
--

John W. Vinson [MVP]
.
John: sorry for the delay in replying. I do appreciate your help.
Click to expand...
Surely I do need a Track Artist Table to store all the names, so that I
don't have to ebter the same name every time it occurs? Music Category and
Artist both have tables and forms behind their combo boxes.
Can you suggest what code I would need?
 

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

Combo-box in Sub-form 6
Using a Combo Box to find a Record 20
Creating a Search using a combo box and then creating a report. 4
Dynamic Naming of Form Button 3
Combo or list box 0
Linking to a form from a combo box search 5
Combo or list box 0
Creating a Chart on form from selected data in query. 0

Top