Re: A2K - how to select a record, programatically on a continuous subform

On Aug 30, 9:09 am, "Deano" <de...@xxxxxxxxxxxxxx> wrote:
"OldPro" <rrossk...@xxxxxxxxxxxxx> wrote in message

news:1188481963.084622.168680@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxx





On Aug 30, 8:29 am, "Deano" <de...@xxxxxxxxxxxxxx> wrote:
I have a little search routine going whereby the user types in some text
and
clicks a button on the main form.
I then see if that text exists in a record on the subform. I get a
match,
grab the record id and am now trying to automatically highlight that
record
in the subform to show the user they got a hit.

How can I select that record and then perhaps move the focus into a
specific
textbox?

I'm trying this a number of ways and Access isn't cooperating.

thanks
Martin

It is possible, but it isn't easy. Look at this link:
http://www.mvps.org/access/forms/frm0047.htm

I think that just highlights the current record selected by the user. I
want the program to select the record without any user intervention.- Hide quoted text -

- Show quoted text -

It's the same basic idea, except that instead of comparing the current
record to the selected record in the onCurrent event, you compare the
current record to the record you want hilited. It is possible to do a
multi-select this way too.

.

Quantcast