open the Find And Replace Dialogue with focus on a specific default column

[Colin Hayes]

Hi All

I have a Sendkeys function of ^f to open the Find And Replace Dialogue.

I'd like to modify it so that it opens with focus on a specific default
column.

Is this possible?



Best Wishes


Colin

 

[Klatuu]

You first have to set the focus to the control you want to use the find and
replace on.

 

[Colin Hayes]

You first have to set the focus to the control you want to use the find and
replace on.

HI

Yes , I understand. I

It's just that when I use my sendkey command to open the dialog again ,
the focus is on a different column and means that I have to continually
navigate for it to search down the one I want.

I just need to always focus on the same one when I open it.

Can this be done? Maybe with a macro or SQL?



Best Wishes

 

[Larry Daugherty]

I don't see the first part of your thread so if this is 'way off base
that may be the reason.

Where you have the code to open the dialog, precede that line with one
to set focus to that *control*, not "field".

For general use, there is (or was) a saver version of SendKeys on
www.mvps.org/access named fSendkeys.

HTH
--
-Larry-
--