Button in Access 2016 to add +1 to last/highest value in a field

[Alocin]

Hi and thank you in advance everyone!
I want to add +1 to the highest value in a table field populated by a form control by clicking on a button in this form.




My table called "Requests" has a field called "Request#". I want to add a button in the form called "Add Request" so that when it is clicked, it will add +1 to the highest number in the form control / table field. If there is a macro that can do this I would really love it. VBA is a bit not so easy for me.
however, I am using a VBA code (please see below) that works very well but I have to double click on the form Control "Request#" in order to add 1 to the greatest value in the table
field. I need to have a button that will do the same thing. Any help if so much appreciated.

[Bob Fitz]

..... I am using a VBA code (please see below) .....

You seem to have forgotten to attach the code

[Alocin]

Hi Bob, thank you for your quick reply.

Well, as mentioned I am barely a novice in VBA so I am always hopeful to find what I consider an easier way, macros. I have figured out a way to use a macro.
For the audience in Access 2016 using SetValue the macro is DMax("[FieldName]","[QueryorTableName]")+1. However, in Access 2016 "SetValue" does not show up on the drop down selections, so you must click on "Show All Actions" on the menu bar to see "SetValue".

Bob, now I wonder if you can help on the following issue. I have the same issue on a subsequent form control called "RequestSub#". The table "Requests" has two fields that are associated, "Request#" and "RequestSub#". As needed, I need to have a button that increases the "RequestSub#" by +1; however, it must increase based on the associated "Request#". Does this make sense?
In other words based on the request# the associated requestsub# will increase by +1 as we have the entry.
here is my example:
Request# RequestSub#:
365 0 <--initial start value is 0
366 0
365 1
367 0
365 2
366 1
etc.
Any help is so much appreciated. Also, should I make this another post/question?

[Bob Fitz]

Alocin

1) It's not a good idea to name any Access object using spaces or special characters like "#". Only exception is the underscore "_"

2) Like most Access users with some experience, I do not use macros as we prefer to use VBA code, so I would be unable to help with those. That said, there is a striking similarity between what you posted:
DMax("[FieldName]","[QueryorTableName]")+1
and the kind of code that we would use, which would be the DMax() function with some criteria. Something like:
DMax("[FieldName]","[QueryorTableName]","[NameOfTableField] = " & Me.[NameOfFormControl])+1
if the "NameOfTableField" was numeric type. Syntax would be slightly different it were text.

I would be happy to attempt to find a solution using code if you could post a copy of your db with just a few dummy records to show the problem.
Compact and Repair the db, then "Zip" it before posting.

[Alocin]

Good morning everyone,
thank you to all who tried to help me with this question. I eventually got a macro to work using "SetValue" and the "DMax("[Request_Number]","[Requests]")+1".
Btw I am now posting a different question and looking hoping you fine intellectuals can help me solve.


Again thank you all very much!
Alocin