Selecting An Item In A Combobox (1 Viewer)

[jrmellis]

I have a form with a list box with items in it. I want when I double click on a row a form opens and displays the corresponding record. The problem I have is automatically selecting the corresponding item in a combobox on the form being opened which would then display the rest of data.

Thanks for any help.

 

[Travis]

On the Open or Load Event of the New Form, you need to reference the combobox control on the original form

Example:

Me.[NewComboBox]=Forms![Original Form].Form.[Original Combobox]

 

[Pat Hartman]

You need to add the "where" parameter to the OpenForm Method. This will open the new form to the record chosen in the combo.

 

[jrmellis]

If I add "where" won't this filter out the other items? You see, I want all the other items in the combolist to be there but I want to jump to this particular item in the list. Its like making it the default value only you don't what it is.