Double click a combo box to add data

[sam49]

Hi guys can someone please help.

how do i double click on a combo box to add data i have made a combo box to get data from another table and add it to my data input form. but if the data i want is not in the table linked to the combo box, i need to be able to double click the combo box to add dats to the table linked to the combo box.

Help please

 

[pbaldy]

The more common method would be to use the Not in List event of the combo to add to the source table (searching for "notinlist" should turn up the two common methods). If you want to double click, open a form in the double click event of the combo, and requery the combo afterwards.

 

[sam49]

Thanks for the infomation but i am still no wiser, is it possible to point me towards a video tutoril please

 

[vapid2323]

Thanks for the infomation but i am still no wiser, is it possible to point me towards a video tutoril please

Google is your friend,

http://lmgtfy.com/?q=notinlist+video

 

[sam49]

Thanks Vapid2323 for the link but i am still unable to work it out

Ok I have created a table to store the names of people, who read audio books, then I have created a input form to add new books, on this input form I have created a combo box using the control wizard to select data from the book narrator table and it works just fine.
Now my problem I need to be able to double click on the combo box to add new data to the narrators table.
I also understand I need to go to the properties of the combo box and click on the event tab and then on not in list box.
If I click on the small down pointing arrow I get [Event Procedure] then if I click on the three … dots after the small pointing down arrow I get a dialog box with three choices
1 Macro builder
2 Expression Builder
3 Code Builder

I believe if I am right I need the code builder option

If then click on the space just before the down the small down pointing arrow and get the [Event Procedure] then click on the small just to the right I get Visual Basic box with some code in it.

I am then lost so please what do I do now on top of the visual basic window just below the toolbar I have selected the combo box name and then over to the right I have selected not in list.

How do I save this code that’s if I have to save it?

Then I have done the same for the Double click option

But nothing seems to work I still am unable to double click to add a record