How do I position (not filter) to a row in a subform based on user input in
the parent form?

I have a subform keyed on name.  The subform is not updateable (not
enabled). I have a text control on the parent form.     As the user types in
letters I would like to position to the row in the subform that matches
(=>) the text in the parent form control.

For other reasons I cannot use a list box control.

So, I am testing the 'ON CHANGE' event for the text control, but don't know
how to force positioning in the subcontrol based on what I find in
FORM!CONTROL.text

Regards, Marty

HI Marty,

Try using the Recordsetclone of the subform to issue a FindFirst on the
record you want.  If the record is found,  then assign the Clone's bookmark
to the subform's bookmark and the focus should move to the record you want.

HTH
--
Dev Ashish (Just my $.001)
---------------
The Access Web ( http://home.att.net/~dashish )
---------------

:How do I position (not filter) to a row in a subform based on user input in
:the parent form?
:
:I have a subform keyed on name.  The subform is not updateable (not
:enabled). I have a text control on the parent form.     As the user types
in
:letters I would like to position to the row in the subform that matches
:(=>) the text in the parent form control.
:
:For other reasons I cannot use a list box control.
:
:So, I am testing the 'ON CHANGE' event for the text control, but don't know
:how to force positioning in the subcontrol based on what I find in
:FORM!CONTROL.text
:
:Regards, Marty
:
: