Which event to use?

H

Henro

What is the event that is triggered when changing to a new record in the
same form?

Thanks for thinking

Henro
 
P

Paul Overway

Form_Current. You'll also need to test whether you are in a new record
using Me.NewRecord.
 
H

Henro

test using Me.newrecord? Can you explain that?


I just pretend to know something, in fact I know ... (excrement)
;-p

Grtz Henro
 
P

Paul Overway

Me.NewRecord returns a boolean indicating whether the current record is a
new record. See help for details and examples.
 
A

Albert D. Kallal

Do you mean moving to a differnt reocrd, or do you mean adding a new
record?

Moving to a differnt reocrd, you can use

on current.

Adding a new reocrd, you can use on-insert.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Which event? 8
VSTO C# add in Outlook.Appointment error 0
AFTERUPDATE Event 3
change label on subFORM in REPORT 4
Change field form Long to Double Precision 2
HELP WITH TAB CONTROL - HIDING FIELDS 7
Test form for changes on close 6
How do I set focus (and select text) on a text box on a modeless userform? 0

Top