Help with gotocontrol, activecontrol

[k9drh]

Well here's a new twist I would love some ideas on.


I have a membership sign-in form that works great. Very simple scan bar code or manual <enter> populates info fields and TABS to Save and record. Then active control returns to scan bar code field. The problem is there is a Vistor Button on the form which opens a seperate form. Enter the visitor info and close. now comes the problem. The active control is still on the visitor button. I have tried to find a way to get the active control to go back to TAB1. I have tried docmd.gotocontrol also tried screen.activecontrol to force focus back to TAB1 from Visitor Button when form closes.
Is there a way to force focus back to TAB1?

[pbaldy]

I would try setting focus to the desired control in the On Activate event of the form. That should fire when the visitor form closes.

[k9drh]

it is already set to docmd.gotocontrol "callsign" which is TAB1

[pbaldy]

Can you post the db?

[k9drh]

well you were right my mistake in spelling or something.
I had forms.onactivate set in VB code. Removed from there and made it a macro gotocontrol and that did work.
Thank you for jogging the brain.

[pbaldy]

No problem, glad you got it sorted out. Welcome to the site by the way!