Differenc between Lost Focus and On Exit

[Jacqueline]

Can someone explain the difference between these two events for me please? I
want to creat an event to move the cursor to the first input box on the form
when the user clicks the New Record button.

Thank you,

 

[Beetle]

Use the forms Current event instead.

Private Sub Form_Current

If Me.NewRecord Then Me![SomeControl].SetFocus

End Sub

 

[Jacqueline]

Sean,
I am not the strongest VB user but have ventured into some simple stuff.
However, now that I am in Access 2007 when ever I open the code option box
all I see is the start and stop of the sub routine, no code between.

I have been afraid to mess around with it for fear of messing something up.
I have also made sure my databases are in a "Trusted Folder". Have you run
into this or am I just not hold my mouth right??
Thanks much,
--
Jacqueline

Use the forms Current event instead.

Private Sub Form_Current

If Me.NewRecord Then Me![SomeControl].SetFocus

End Sub
--
_________

Sean Bailey

Can someone explain the difference between these two events for me please? I
want to creat an event to move the cursor to the first input box on the form
when the user clicks the New Record button.

Thank you,

 

[Beetle]

when ever I open the code option box all I see is the start and stop of

the sub routine, no code between.

That's all you should see unless you have previously put some code in that
event. In other words, if you open the properties sheet for your form, go
to the Event tab, click the build (...) button to the right of the On Current
event and select Code Builder, the code window should open displaying
the following lines;

Private Sub Form_Current ( )

End Sub

All you would need to do is put;

If Me.NewRecord Then Me![SomeControl].SetFocus

in between those lines, using your actual control name in place of
[SomeControl]. If your db is in a trusted location, then the code should
work. If you're worried about making a mistake, just make a backup
copy of your db before you make any changes (which you should always
do anyway).
--
_________

Sean Bailey

Sean,
I am not the strongest VB user but have ventured into some simple stuff.
However, now that I am in Access 2007 when ever I open the code option box
all I see is the start and stop of the sub routine, no code between.

I have been afraid to mess around with it for fear of messing something up.
I have also made sure my databases are in a "Trusted Folder". Have you run
into this or am I just not hold my mouth right??
Thanks much,
--
Jacqueline

Use the forms Current event instead.

Private Sub Form_Current

If Me.NewRecord Then Me![SomeControl].SetFocus

End Sub
--
_________

Sean Bailey

Can someone explain the difference between these two events for me please? I
want to creat an event to move the cursor to the first input box on the form
when the user clicks the New Record button.

Thank you,

 

[Mike Painter]

Can someone explain the difference between these two events for me
please? I want to creat an event to move the cursor to the first
input box on the form when the user clicks the New Record button.

Thank you,

See the note on this page.
http://msdn.microsoft.com/en-us/library/bb238441.aspx