I have a form based on a table that used for data entry. One of the fields in the table is set as a required element. On the form, i have a button with which i can clear the current contents of the form (in case they mees up). however it does not like the required element and gives me an error...
i'm using a union query in a combo box to add the "ALL" option to my selection list (as found around here as an faq i believe)but my problem is that the no matter what i seem to do it's treating my sort like texts not numbers
for ex after adding the union it sorts like this:
1
11
12390
12391
2...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.