General information
Category:
Forms & Form designer
Title:
Text box with numbers
I have a table with code an description
In the form I use a textbox to get these values. For the code I use an input mask of 99999.
I check for the code so that it does not repeat when adding a new item. Also I check that both code and description are added.
The problem is when I add an item, the default value for the code is zero, although no value is displayed. If I check for this value for not null it returns false (because it has a zero). If I add a description and save it, it saves the description and .null. for the code. If in the list I have another item with a zero code, the routine will tell that the code already exists.
How can I achieve what I want? It seems simple, but I been messing too much around with it without getting a result.
Thanks
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only