Setting focus problem 1

[delman333]

I have 9 groups of 4 comboboxes on the form...but at any given time there can only be one set of four enabled. I use GotFocus events on each set of four so that the user must enter data in the correct order of comboboxes. As the user enters data in the first enabled box...the focus automatically moves to the next appropriate enabled box. When data is selected in the last of the four boxes that group is disabled and the second set is enabled...and so on down the entire set of 9 groups.

However...I have an editing procedure command button that brings up a dialog box. If the user selects Yes to open the Group Edit Selection Form all the groups are disabled and the uer may select which group to edit...this also works fine. But if the user changes their mind and selects No to not open the form...I am having trouble returning the focus to the correct point where they left off.

This seemed like a simple problem at first...but my limited experience quickly ran out of ideas. Any suggestions would be greatly appreciated.

 

[wemeier]

You could try saving the name of the control that the user was last on (based on GotFocus events) in a variable:

Dim strLastFocus as String

Private Sub cboField1_GotFocus()
strLastFocus = "cboField1"
End Sub

Then use the contents of the variable to set the focus again if the user selects "No":

Me(strLastFocus).SetFocus

Or, if you need to save the NEXT control the user was going to (it seems you are setting that now in each prior control's GotFocus event), save the control name that you will NEXT set focus to in the string variable.

Cruising the Information Superhighway
_{(your mileage may vary)}

 

[delman333]

It's always the simple fixes that are so cool. It works great! Thanks.