Command Button Wizard

Command Button Wizard - Find Record

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Mike Langensiepen - 26 Feb 2007 05:14 GMT

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

Reply to this Message

Daveo - 26 Feb 2007 10:09 GMT

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

Reply to this Message

Mike Langensiepen - 27 Feb 2007 02:52 GMT

Thanks - I'll give it a go

> Hi Mike,
>
[quoted text clipped - 11 lines]
>
> Cheers - David

Reply to this Message

Mike Langensiepen - 27 Feb 2007 02:54 GMT

Worked perfectly! - ta very much

> Hi Mike,
>
[quoted text clipped - 11 lines]
>
> Cheers - David

Reply to this Message