Please Help!! Combo Box selection

[Guest]

I use a combo box to control another combo box, once the combo box has the
required info in it I then click a command button to open a file. The combo
box is used in opening this file, as shown:

where SelectWorkStation = combo box 1
WorkInstruction = combo box 2

"\\Mercury\Users\Trim Line Work Instructions 2006\" & _
Me.SelectWorkStation.Column(1) & "\" & Me.WorkInstruction.Column(3) & "

Problem is that if the user doesn't click on the combo box 2 then the file
doesn't open although the correct file path is displayed on screen.
Is there any way of not having to click on the combo box to give it
'focus'????

Thanx in advance....

 

[Guest]

You could have the lost focus of combo box 1 make combo box 2 have focus.

private sub Lost_Focus_cmb1

me.cmb2.setfocus

end sub

 

[Guest]

Doesn't work .... The focus can be moved to the combo box, like as if you
tabbed to it, but code still doesn't recognise its been updated. The only way
it does recognise is if you select it using the mouse (it turns Black).......