Set value of field in table to number that equals current recordset 1

[cstringer]

Hello all,

I have a form to enter info into a table called "Database". In this table there is a field called "ID" (Data Type: Number). Is there a way I can set the value of this field to equal the current recordset number by using one of the events on the data entry form?

Thanks!

 

[glalsop]

You can use the Form_current event:

Me.ID = Me.CurrentRecord

-Gary

 

[cstringer]

Worked great! Knew it was something simple, but I guess you can look at something too long and go brain dead.
Thanks!