A
A. Smart
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 select it????
I progammed it to have focus after an update but that still didn't work.....
Thanx in advance....
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 select it????
I progammed it to have focus after an update but that still didn't work.....
Thanx in advance....