Command Button Wizard - Find Record

[Mike Langensiepen]

I use the Command Button Wizard Find Record option in a data entry form. The
problem is that I want it to preselect searching the whole form rather than
the field it starts up with. To get it to work as I want it you have to
change the 'Look In' selector to FormName: Form every time. Is there an easy
way to force this when you click on the Find Record command button?

Thanks

Mike

 

[Daveo]

Hi Mike,

Not sure if this is the right way, but you can achieve what you want
by removing the "Screen.PreviousControl.SetFocus" line of code from
behind the button.

To do this:

Switch to design view.
Go to the command button's properties.
In the events tab, click on the "..." button next to the On Click
Event.
Delete the "Screen.PreviousControl.SetFocus" line.

Cheers - David

 

[Mike Langensiepen]

Thanks - I'll give it a go

 

[Mike Langensiepen]

Worked perfectly! - ta very much