Search results

Thanks! i have successfully created the running number option.. but another problem arises.. Whenever i create new data base.. the PO number is auto generated.. but when i refer back to my table (PO).. It only shows the latest creation and the rest of the records is lost... :banghead:

i type the following and end up with the error below If Me.PO number = 0 Or IsNull(Me.PO number) Then Me.PO Number = Nz(DMax("PO number", "PO"), 42990) + 1 End If Compile error: syntax error

Hi, I have found the box and i copy the codes in.. But it still doesn't work. You have mention something about the field name... Where do i change it? In the form, the running number is under "PO number" column, and the form is created under "PO generator" table.

Dear John, So sorry, i do not understand the (Form's On Current Event).. where do i find this On Current to key in the Code? Also, after keying in the codes, how do i lock column in the form so that user can only key in the fields that are required? Thanks!

Hi all, i have looked at the Zip file.. How do you lock the Form 1 f1ID and create a running number starting at 42990? Please help thanks!

Hi Mstef, i am unable to open the file.. please help.. Thanks!

Hi, i am super new in using access and i am facing a problem with creating a running number starting with 42990.. I try creating with Auto number but the number start with 1 and i can't change the seq to 42990. Can anyone please help me. thanks!