NewRecord?

[mwabbe]

Is there anyway to code behind that is pushed on a form after data is entered to test if it is a new record?

[pbaldy]

If Me.NewRecord Then

[mwabbe]

that is what i thought but it is not working right. here is the whole if..then:

If Me.NewRecord Then
        DoCmd.OpenForm "Benefits", , , , , acDialog, Me.ID & ";" & Me.First_Name      & ";" & Me.Last_Name
        Else
       DoCmd.OpenForm "Benefits", , , "[EmployeeID]=" & Me.ID, , acDialog

[pbaldy]

You're missing the "End If" if that's all the code. If not, what does "not working right" mean exactly?

[mwabbe]

I just missed that in the copy, it is there. well, if I am on a new record and I click that button it does not pass the openargs.

[weekend00]

I am thinking when you click "the button ", the record had grown "old".
( I never work on any new record, so I am not sure if I am right, just a remind)

[pbaldy]

What event is the code in? The form is bound to a table?

[mwabbe]

the code is behind a button. and the form is bound to a table

[weekend00]

What event is the code in? The form is bound to a table?

he said the event is a click on some button.

[pbaldy]

Can you post the db?

[mwabbe]

i guess im not sure how to upload it

[mwabbe]

i Figured it out

[mwabbe]

The code is a bit messy

[pbaldy]

It appears you grabbed the lock file (.laccdb) instead of the actual file (.accdb).

[mwabbe]

indeed i did, but now its not letting me. says im missing a security token