add new item to list box

[kes]

hi,

I have a list box on a form and I would like the user to have the possibilty to add another item not from the list into the table using a command button.
how can I do that?
thanks for the helpers!

 

[pbaldy]

One way is to open a form bound to that table, then requery the listbox.

 

[kes]

And in that form what should i write in the command button?
I want the users to have the option to add items that not on the value list

 

[pr2-eugin]

Look into the NotInList event of the listbox.. If you want to add through button.. On click if the button, use..

DoCmd.OpenForm "theBoundFormName", DataMode:=acFormAdd

 

[pbaldy]

I'm on an iPad right now, but does a listbox have a not in list event? You can't type into it.

 

[pr2-eugin]

I'm on an iPad right now, but does a listbox have a not in list event? You can't type into it.

Thanks for coming along Paul,

That is my bad.. The event is not exactly called Not in List.. It is "List Item Edit Form", which is similar to the NotInList event.. Sorry Kes..

 

[gemma-the-husky]

Thanks for coming along Paul,

That is my bad.. The event is not exactly called Not in List.. It is "List Item Edit Form", which is similar to the NotInList event.. Sorry Kes..

when did that come in, Paul?

I haven't seen that option before.

 

[pr2-eugin]

I am using Access 2010, it has always been there..

 

[pbaldy]

I believe that feature was introduced with 2007.

 

[kes]

Hi, pbaldy is right... It's a list box... I can't type into it, so the not in list event can't happend...

 

[pr2-eugin]

You have Access version < 2007?

 

[kes]

no. I have 2010... the option exists, but because I can't type to a list box nothing happend (not on list event can't happend)