default number in form

[Guest]

hello,
is there any kod wich will give us as defult
the sequnt 'id' number of the 'id' number in the latest record ?
thanks,

 

[Jeff Boyce]

I'm not clear on what you mean by "sequence ID number of the ID number in
the latest record".

Are you using an Access Autonumber field as the ID, or do you have a
customized routine that generates a sequence number?

--
Regards

Jeff Boyce
Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/

Microsoft Registered Partner
https://partner.microsoft.com/

 

[Guest]

thank you Jeff
I customized routine that generates a sequence number not autonumber.
i found the answer from other qustion;
here,

Private Sub Text28_AfterUpdate()
Me.Text28.DefaultValue = Chr(34) & Text28 + 1 & Chr(34)
End Sub

yariv