forms cannot save the data

[rahultiwari]

Hi..
I cannot save the data in the forms I have made. once I close the form, all the saved infomation is lost when I reopen the form. But somehow they reman stored in the table.
Any suggesstion on how to retain the records in the form too.
Regards
Rahul

 

[maxmangion]

when you are opening the form, have you set it to go to a new record ?

 

[rahultiwari]

No, the form always start with the first record. and then I naviagate to new record manually and even if I enter 10 records they are saved only in the table not in the form itself.
I dont know how to make it go to a new record anyways, so please let me know how to do it.

Regards

 

[adevera]

once you close the form and re-open it, it will display the first record on your table attached to that form. however, you can do the follwing:

1. create a query based on the table and set the property to descending provided that you have at least a primary key or index field, or

2. create a code in the open even of the form that will point the last record on the table

 

[Pat Hartman]

Forms don't save data, tables do. Tables are the only persistant data storage. Think of forms as windows into a table through which you can view or update data.