which record referenced in combobox choice

[Joanne]

I have a combo box based on a table listing my files

When the user clicks on a filename in the combo box I need to be able
to auto open msword (I know how to do this) and show the document that
was chosen.

My problem is how do I capture which doc was chosen - by this I mean
that if the seventh doc in the list was chosen how does my sub routine
know which doc to open. Do I reference row 7 of the combo box?

I am really confused. Please help

 

[Ken Snell [MVP]]

When the user clicks on the combo box, that item is selected. The value of
the combo box then becomes whatever the value of the Bound Column is. You
can just refer to the combo box's value to get this result.

 

[Joanne]

Thanks Ken - that sounds like something I might be able to do