Command Button Wizard - Find Record

  • Thread starter Thread starter Mike Langensiepen
  • Start date Start date
M

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
 
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
 
Back
Top