Go To...

[alex]

I have a Form that encompasses more than a full screen, i.e., users
need to use the V scroll bar.

I have a command button at the bottom of my form for adding a new
record.
When a user triggers the add new record, however, the focus/cursor
does not automatically go to the first record.

What's the best way to solve this problem?
Can I add code directly to the on click event procedure for the add
new record?

As always,
Thanks for the help

alex

 

[Guest]

I use the GoToControl command after adding a record

DoCmd.GoToRecord , , acNewRec
DoCmd.GoToControl "Caller" '<-- change caller to the name of your
control (the name of your text box, combo box, etc.).


Bryan

 

[alex]

I use the GoToControl command after adding a record

DoCmd.GoToRecord , , acNewRec
DoCmd.GoToControl "Caller" '<-- change caller to the name of your
control (the name of your text box, combo box, etc.).

Bryan









- Show quoted text -

Thanks Bryan for your help.
I tried exactly what you suggested...I get a compile error: Argument
not optional

alex

 

[alex]

Thanks Bryan for your help.
I tried exactly what you suggested...I get a compile error: Argument
not optional

alex- Hide quoted text -

- Show quoted text -

Bryan

I think I got it to work...I needed () and ""

 

[alex]

Bryan

I think I got it to work...I needed () and ""- Hide quoted text -

- Show quoted text -

Bryan,

Before I go to the control, is there a way (code) to 'go to top of
page.'
Reason: when i go to the control, there's other labels at the top
that i would like to be displayed.

alex

 

[Guest]

Never needed to do that. That sounds hard.

Try this after the GoToControl:

DoCmd.GoToPage (1)


B..

 

[alex]

Never needed to do that. That sounds hard.

Try this after the GoToControl:

DoCmd.GoToPage (1)

B..






- Show quoted text -

It works Bryan. Thanks for your help.

alex