Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Form Counter

Status
Not open for further replies.

cdw0308

Technical User
Oct 8, 2003
181
US
I have an access database program that uses this code to put a number on the form based on what the last form number was.
It happen when the form loads. I am rewriting the program to be web-based. I need to know how to do the following in javascript.

Code:
Private Sub Form_Current()
 
 If Me.NewRecord Then
    On Error Resume Next 'It should never occur, just to be sure...
    Me!tran_ID.DefaultValue = Nz(DMax("[tran_ID]", "delivery"), 0) + 1
    
  End If
End Sub

Any help is appreciated.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top