counter

[antonov]

hello everybody....
I have this mask in which I need a counter. This counter has to have the
number and the first 3 letters of the current month (i.e. 10/oct).
This counter has to be activate by a command button (when I am in a form and
I click on "new" this will open a new form and the counter will then jump to
the next available number).
How can I achieve this?
Thanks for any help

 

[Steve Schapel]

Antonov,

I am pretty sure I understand what you mean.

Have a field, number data type, in the table that the form is based on.
On the form, put a textbox bound to this field, but set its Visible
property to No.
Set the Default Value property of this textbox to the equivalent of:
DMax("[YourNumber]","YourTable")+1
Put another textbox on the form, and set its Control Source property to
the equivalent of:
=[YourNumber] & "/" & Format(Date(),"mmm")