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

[Deano]

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

[OldPro]

On Aug 30, 8:29 am, "Deano" <de...@mailinat or.comwrote:

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

[Deano]

"OldPro" <rr*******@sbcg lobal.netwrote in message
news:11******** **************@ 19g2000hsx.goog legroups.com...

On Aug 30, 8:29 am, "Deano" <de...@mailinat or.comwrote:

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.

[Salad]

Deano 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

I have, on most continuous form, a text box above each column that the
users can enter text, numbers, dates to search on. Uses the F3 key to
find the next one. It's gotten pretty generic for me to create such a
form. But the basic concept is to find the rec and move to it. Let's
say the continuus form's key is called ID. You search the LastName
field for Smith.
Dim rst As Recordset
set rst = Forms!MainForm! Subform.Records etclone
rst.findfirst "LastName = 'Smith'"
If not rst.Eof then
Forms!MainForm! Subform.Bookmar k = rst.Bookmark
Else
msgbox "Not found, try again."
Endif
rst.close
set rst = Nothing

[OldPro]

On Aug 30, 9:09 am, "Deano" <de...@mailinat or.comwrote:

"OldPro" <rrossk...@sbcg lobal.netwrote in message

news:11******** **************@ 19g2000hsx.goog legroups.com...

On Aug 30, 8:29 am, "Deano" <de...@mailinat or.comwrote:

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.