Scorecard Question (Combo box)

[Fatti]

Im building a small database for a sports event and am having some issues with a Combo box (or more correctly a series of combo boxes).

What I want on the form is a series of combo boxes in a single column all linking to the competitor table so I can select a competitor from a list, then record their scores along side their name and other details.

Should the competitor not be on that list, I want he ability to add a new competitor name (or even another form opens up to enter their details).



The form will have 40 rows with Competitor name, Score and related event details.

Once this is done I then want to be able to save that entire page as a competition (This I will just add to the competition table and then later filter by date and event if need be).

So the problem I am having is producing an editable combo box where I can save those details to the database to add another competitor. Im fairly certain im not the first to do this so there must be a solution out there somewhere.

Any assistance you can offer would be much appreciated.

[pbaldy]

Search here on "notinlist" and you should turn up the two common methods. Basically you use the Not in List event of the combo to add new items. One of the methods pops up a form to add details.

[Fatti]

Cheers for that. Just what im looking for.

[pbaldy]

Excellent, happy to help.