Hi all:
Maybe you could help me with another bug I’m having.
I have a form with 2 combo boxes. One queries by a part’s number, and the other queries by a combination of a part’s machine type and description. The user selects either one of them for the purpose of adding more parts into the inventory. After the add, he is prompted with a message box ‘are you going to add more?’(vbYesNoCancel). Upon choosing yes, set focus appears to correctly put focus onto a control that is out of the view of the user, again leaving available for selection either of the combo boxes. However, one of the combo boxes consistently [prompts for the user’s input] without being selected, and immediately after choosing “yes”. It’s always the same combo box. If I click cancel to end that query, the [prompt for the other combo box] appears… click cancel there, and the curser is not showing anywhere, presumably because it’s where it should be, on the control that is out of view. Both boxes are configured exactly the same as each other. The only tab stop is on the control that is out of view. This is what I have:
DoCmd.Save
Combo246.Value = ””
Combo265.Value = “”
Me.Refresh
TabHold.SetFocus ‘control that holds the curser out of view’
I use Me.Refresh because I want the Combo box to immediately show the updated quantity value. What am I doing wrong here?
chuck
Maybe you could help me with another bug I’m having.
I have a form with 2 combo boxes. One queries by a part’s number, and the other queries by a combination of a part’s machine type and description. The user selects either one of them for the purpose of adding more parts into the inventory. After the add, he is prompted with a message box ‘are you going to add more?’(vbYesNoCancel). Upon choosing yes, set focus appears to correctly put focus onto a control that is out of the view of the user, again leaving available for selection either of the combo boxes. However, one of the combo boxes consistently [prompts for the user’s input] without being selected, and immediately after choosing “yes”. It’s always the same combo box. If I click cancel to end that query, the [prompt for the other combo box] appears… click cancel there, and the curser is not showing anywhere, presumably because it’s where it should be, on the control that is out of view. Both boxes are configured exactly the same as each other. The only tab stop is on the control that is out of view. This is what I have:
DoCmd.Save
Combo246.Value = ””
Combo265.Value = “”
Me.Refresh
TabHold.SetFocus ‘control that holds the curser out of view’
I use Me.Refresh because I want the Combo box to immediately show the updated quantity value. What am I doing wrong here?
chuck
