setfocus error

I would like to set the focus on the CheckTrip_CB1 command button text box MilesPaid_TB1 is empty to avoid the user having to tab through about 10 fields that are irrelevant because that certain condition is met. When I run this code, I get runtime error '-2147467259 (80004005)' unspecified and...

I'm trying to select a textbox from my form in excel with the command #set focus "but apparently it gives me an error, can someone help me? Error: Private Sub cmd_Recheck1_Click() A0r = in_A0r.Value A90r = in_A90r.Value A_90r = in_A_90r.Value A1 = 0 A2 = A90r - A0r...

I'm using this code to evaluate the value of a textbox on a UF. If the value is invalid, a msgbox is triggered. Once the EU clicks the OK button, I want the focus back on the offending textbox. Instead, the focus is moving to the next textbox, which also has similar validation occurring, so...

Hi This is my first question. I have a command button (SaveChangesBtn) that I wish to set focus to under certain circumstances. On many occasions the button works fine, but occasionally I get an unspecified run time error. It is at the following point in the code POpenIssuesRowID = r.Row -...