Solved An unbound field on a form to:

[UnrealEnvy]

Hello,
I need to know how can I make an unbound field on a form that will have a value of: eg: 500
and the next time I will open it, it will be 501
the time after, 502
and so on and so forth.

This form isn't based on a table, so I cannot do it with autonumber, I need to be able to do that on a designed form.

Macro maybe? Can someone please assist?

 

[HiTechCoach]

How will you know the last number used?

If it is stored in a table someplace, you could use the DMAX() to look up the last number and then add 1.

See if the attached example helps.

 

[UnrealEnvy]

How will you know the last number used?

If it is stored in a table someplace, you could use the DMAX() to look up the last number and then add 1.

See if the attached example helps.

The number isn't stored on any table. Is there a way to add an inbound field to my form and put a value on it, and then start counting +1 everytime I open that form? Please assist.

 

[boblarson]

The number isn't stored on any table. Is there a way to add an inbound field to my form and put a value on it, and then start counting +1 everytime I open that form? Please assist.

You have to store the last number somewhere and a table is the most logical given the availability of tables to the program. You could also store it in a custom property, but I typically prefer to use a table.