Hi everyone,
I need some help with MS Access.
I need to get information from a specific field in the latest record (to write it in some textbox), and then in a new record write some data to the same field.
I tried to get the last record by using "movelast" function and then, in the new record I opened I wrote the information.
but what accually happent is that the data I wanted to write in the new record was writen down both in the new record and the latest one (deleting previous data in that field).
I hope someone can help me.... I'm wasting a lot of time on this thing....
thanks, Shiry