How To Determine New Record

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

AKA Spawn - 10 Jul 2005 03:23 GMT

Hi Again,

I have a table named StudentProfile and I need to know if the current record
is a new record.

What is the code that will let me know that?

-AKA

Reply to this Message

Allen Browne - 10 Jul 2005 07:03 GMT

To control the interface, use a form, not the table directly.
Use a form in Datasheet view if you want it to look like a table.

You can then test the NewRecord property of the form.

Signature

Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

> Hi Again,
>
[quoted text clipped - 5 lines]
>
> -AKA

Reply to this Message

AKA Spawn - 10 Jul 2005 15:43 GMT

Thanks Allen for the info. God Bless!

> To control the interface, use a form, not the table directly.
> Use a form in Datasheet view if you want it to look like a table.
[quoted text clipped - 10 lines]
> >
> > -AKA

Reply to this Message