I HAVE A TABLE WITH FIELDS ITEM, RATE
I HAVE A FORM BASED ON ABOVE TABLE
IF I TRY TO ADD VALUES IN TABLE USING INPUTBOX , IT DOES NOT GET ADDED.
IF I OPEN THE FORM IN CODE AND ADD THE INPUTBOX VALUE IN [FORMS]!FORMNAME]![FIELD],IT GETS ADDED.
IS IT NECCESSORY TO OPEN FORM TO ADD DATA IN FIELDS...
THE RECORDS GET ADDED RANDOMLY IN A TABLE
AND THE QUERY BASED ON THIS TABLE DOES NOT WORK PROPERLY AS IT CAN NOT READ LAST RECORD CORRECTLY, BECAUSE THE LAST RECORD GETS INSERTED SOMEWHERE IN TABLE AT RANDOM.
WHAT TO DO ,TO ENSURE THAT THE RECORDS GET ADDED ON 'FIRST ADDED FIRST RECORDED' BASIS...
new records in a table get added randomly.
and the query based on this table does not work properly as
it never reads the last record correctly
what to do so that the records get added on first come basis?
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.