Form append mode?

[Codebug]

How can you check if a form is in append mode (ie new record)

  If MyForm = '  Append Mode ? Then
   
      ' my code

   End If

[FishVal]

Something like
[code=vb]
If MyForm.DataEntr y Then ....
[/code]

Regards.
Fish

[Codebug]

Thanks,

overlooked the obvious

[FishVal]

Not a problem.
Good luck.

[missinglinq]

How can you check if a form is in append mode (ie new record)

Fish's code will work if the form is opened using acFormAdd or if the form's AllowAdditions property is set to Yes, but if by "if a form is in append mode" you simply mean that you've moved to a new record,as opposed to an existing record, you need to use something like this:

If Me.NewRecord Then
  'Place your code here
 End If

Welcome to TheScripts!

Linq ;0)>

[Codebug]

Yes thanks, NewRecord that worked!

[missinglinq]

Glad we could help!

Linq ;0)>