Increase previous field By one number

[dead7]

I have a field on a form that I need increase by 1. Its a page number field for extra pages of data. Its a number field from table. Im need a CMDBUTTON that when pressed will goto a new record but the PAGE field will increase by 1. So if the starting record is PAGE 1, when button is pressed it goes to a new record and PAGE 2 is set for the new record. HELP PLEASE

 

[PHV]

Have a look at the DMax function.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[Pigster14]

If this field is located on the form and is stored in the table, could you not create that field in the table to be an AutoNumber field. Then you can edit in the properties for what number you want it to start at and increment by. It defaults to start at 1 and then increments by 1. Then you will not have to build code in your form.

Good luck!