This if my first post.
I am very new so forgive me if i ask several questions.
I have a database, In forms i have two different memo field.
1. dailymemo. 2. monthlymemo
dailymemo is a text field that is uniqe in every different record. so everyday i write momo in it and it stays with that record, that works.
monthlymemo is text field that i would like to stay the same with each record, if i go to new record the monthlymemo shoud be there with memo i wrote lasttime. but the problem is with new record text in monthlymemo does not stay, if i go to new record it become empty.
so how i can retail the value in monthlymemo so that it is always there no mater what record i go to