Drop Down Box updating

[bennybee]

I have a form based on a table which has a drop down box refering to another table.
ie.
I have a table and on it is a drop down box with venue names in it, so that the user can select the venue which they want the record to relate to.

Is there any way that if the venue the user is wanting the record to refer to is NOT in the drop down box, that they can enter it, and it will be stored in the table storing all the other venue names, and at the same time, be stored in the table which the form is based on.

So for instance if Sydney All Sports Club is not in the Venue table, the user can enter that name in the drop down box field, and it will be stored in the Venue table, and also in the table which the form is based (there is a field in the table which is a lookup value of the venue table).

I want this so that next time when i create a new record, if i want the record to be related to the Sydney All Sports Club, the name will appear in the drop down box, and can be easily selected, without the user having to type the name in again.

is this possible??

 

[Pat Hartman]

You can search help, the Microsoft knowledge base, and the archives here for "NotInList event" for example code.

 

[bennybee]

What is the code that i have to put in the [Event Procedure]

i have never done any VB code, so i dont know where to start.

but you are right, the NotInList thing is what i want, but it doesnt give me the code that i need for it to add to the drop down box list.

so what should the code be to add the entry to the drop down box for future reference, or can i do it with a macro?

thanks

 

[Pat Hartman]

I searched the kb for you. This is really an easy example to find which is why I suggested that you could search yourself:

Use NotInList Event to Add a Record to Combo Box

I choose the A2K and newer version. There are 2 older versions. If you run into problems, there are also several problem resolution articles.