Setting Focus to another Open Form

[SteveE]

I have a validation program running on scanned barcodes, when an error or a missed scan is returned I have an error trap which opens a form (or report) which displays the errors. The operator then acknowledges the errors and the form closes and scanning continues. All works fine, however the scanning process is a continuous operation and the conveyer does not stop, several units can pass through the reader while the error message is displayed and because the focus is on the error form not in the validation field of the main form the scans are not recorded.

I need to be able to put the focus back in the validation field on the main form as soon as the Error Form opens while keeping the Error form open, so scan counts can continue behind the Error Form. (this displays the number of scans made from the point of error so the units can be re-checked) apologies if this is unclear but I have tried putting in the on-open event of the Error Form this setfocus code “ Forms!Validation!Input1.SetFocus “ but it does not work, can this be done or I am approaching this wrong?

Any help appreciated.
Steve

 

[namliam]

forms("yourFormName").SetFocus

Will set focus to any selected form that is open.
However when handling the error will focus not always be on the error for if even just for a second when the user presses OK...

 

[SteveE]

Thanks for the reply I have tried that but the focus does not move away from my Error form (on this form there are no Tab Stop set on any controls) ?

Steve

 

[namliam]

That will not work if your error form is on "dialog" or Popup... Popup will always have focus...

Otherwize I am positive it should work.

 

[SteveE]

My warning form was set to dialog but I have changed it to thin, still no luck though. I have tried this on a dummy DB just to see if I can get focus to change from one form on opening to one that is already open but cannot ?
Steve

 

[namliam]

Both forms cannot be "on top" .... you have to have "normal" forms to make it work.

 

[SteveE]

Many thanks for taking the time to help here, I have re-checked nad both my formas are "normal" type, still cannot get focus to move back to the original form on-opening the Error Warning form.

Steve

 

[namliam]

Use the "on got focus" event to set the focus elsewhere...

See attached 2k database, open form1 click the button and see what happens... I think it does what you want it too.

Greets

 

[SteveE]

Magic works great thank for all your help
Steve