In Access 200/2002 I would like to use one form component
(control button/text box) to, on click, cause a particular
other form component to move to the top of a stack of like
components and receive focus.

That way I can use one userform to hold more info.

any ideas on how to do that? I cannot find "bring to
front" as an option in properties or "on click"

Do not want to use tab controls ... need a different look
and feel.

Thanks,
JR

IIRC, the Control that has the Focus will be automatically brought to front.
Thus all you need to do is to set the Focus to the Control that you want to
bring to the front.

--
HTH
Van T. Dinh
MVP (Access)




"JER" <(E-Mail Removed)> wrote in message
news:1454301c413b1$f77537d0$(E-Mail Removed)...
> In Access 200/2002 I would like to use one form component
> (control button/text box) to, on click, cause a particular
> other form component to move to the top of a stack of like
> components and receive focus.
>
> That way I can use one userform to hold more info.
>
> any ideas on how to do that? I cannot find "bring to
> front" as an option in properties or "on click"
>
> Do not want to use tab controls ... need a different look
> and feel.
>
> Thanks,
> JR

Thanks,

Gave it a try:

Private Sub Box5_Click()
Box8.SetFocus
End Sub

most likely I didn't quite get it because it didn't
function as desired.


>-----Original Message-----
>IIRC, the Control that has the Focus will be
automatically brought to front.
>Thus all you need to do is to set the Focus to the
Control that you want to
>bring to the front.
>
>--
>HTH
>Van T. Dinh
>MVP (Access)
>
>
>
>
>"JER" <(E-Mail Removed)> wrote in
message
>news:1454301c413b1$f77537d0$(E-Mail Removed)...
>> In Access 200/2002 I would like to use one form
component
>> (control button/text box) to, on click, cause a
particular
>> other form component to move to the top of a stack of
like
>> components and receive focus.
>>
>> That way I can use one userform to hold more info.
>>
>> any ideas on how to do that? I cannot find "bring to
>> front" as an option in properties or "on click"
>>
>> Do not want to use tab controls ... need a different
look
>> and feel.
>>
>> Thanks,
>> JR
>
>
>.
>

Probably not the Click Event as after the code is executed the Click action
will send the Focus back to Box 5.

Try the GotFocus Event of Box5 (or a CommandButton). As soon as Box5 gets
the Focus, the Focus will be move to Box8 and Box8 will be on top.

--
HTH
Van T. Dinh
MVP (Access)



"JER" <(E-Mail Removed)> wrote in message
news:146cc01c41405$143b0220$(E-Mail Removed)...
> Thanks,
>
> Gave it a try:
>
> Private Sub Box5_Click()
> Box8.SetFocus
> End Sub
>
> most likely I didn't quite get it because it didn't
> function as desired.
>
>