List box selection carried to another form

[paulcraigdainty]

I have searched the forum and just can't find an answer. I'm hoping someone can point me in the right direction.

I have a main form with a combo box that links to a table called tblSTC. There are however hundreds of records to choose from. To make the serach more simple for the user there is a button next to the combo called 'Search', When the user presses this a new form pops up with a text box and a list box (the list box contains all records in tblSTC). As the user starts to enter text into the textbox an AfterUpdate event limits the records displayed in the list box to match the criteria of what has been entered in the text box.

When the user identifies the entry he/she wants to select from the list box, I want the functionality of being able to double click the entry, the popup form close and the selection populated in the combo box.

I know that this is probably just simple code using the List Box double click event. I am however unsure how to go about it. Do I need to use some kind of Insert statement??

 

[KenHigg]

When the user double clicks the second combo box, can the code just do something like:

forms!myMainFormName!myMainComboBoxName = me!mySecondComboBoxName


???

 

[paulcraigdainty]

Sounds good

This sounds logical but im unsure how to implement would this be part of an Insert statement?

 

[KenHigg]

No, 'insert' is more of a sql statement...

In the pop-up forms combobox after update event, just put in the code I did above only use the correct form and combo box names...