remcopeters
Registered User.
- Local time
- Yesterday, 23:19
- Joined
- Dec 3, 2012
- Messages
- 31
- I have a table "Quotes" with fields "UserID" and "Quotenumber"
- I have a form "Make quote" with a textfield "txtQuotenumber" and "txtUserID"
With the following code "txtQuotenumber" gets the highest quotenumber for the current "txtUserID" from the "Quotes" table:
It displays quotenumber 1 as "1" but what I actually want is it to be displayed as "0001". Quote 211 will then be displayed as "0211".
I tried this by entering "0000;;_" into the property "input mask" of "txtQuotenumber" but that results in "1".
How can I manage to do this?
- I have a form "Make quote" with a textfield "txtQuotenumber" and "txtUserID"
With the following code "txtQuotenumber" gets the highest quotenumber for the current "txtUserID" from the "Quotes" table:
Code:
=DMax("[Offertenummer]";"[Offertes]";"[Offertes].[Gebruikers-ID]=" & Formulieren![Offerte formulier]!txtGebruikersID)+1
It displays quotenumber 1 as "1" but what I actually want is it to be displayed as "0001". Quote 211 will then be displayed as "0211".
I tried this by entering "0000;;_" into the property "input mask" of "txtQuotenumber" but that results in "1".
How can I manage to do this?
Last edited: