Counter problem

[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).
and has to be activated 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

 

[Guest]

First, write a function that calculates the number part, assuming it's
unique, then set a text box's Default value to:
=YourFunction() & "/" & Format(Now(),"mmm")

Ray

 

[Douglas J. Steele]

Or

=YourFunction & Format(Date(), " \ \ m m m ")

(Remove all spaces between the quotes in the format function: Outlook
Express is too helpful: it converted it to a hyperlink without quotes!)