Hi,
I have a form with a sub-form. With the help of various threads, I was able to add cmd buttons to "save" (lock fields) and "Edit" (unlock fields to enter/update data) the form and sub-form. I added a Label on frmMain to display "Save" or "Edit" as the caption based on if I click the Save or Edit cmd buttons. It displays well, however, when I close the form and go back into it, the caption is cleared out. How can I get the caption to stay with the entry that I saved it with?
Also - when I re-open the form, the form displays the very first entry. How can I get it to display the most current record?
Thank you
I have a form with a sub-form. With the help of various threads, I was able to add cmd buttons to "save" (lock fields) and "Edit" (unlock fields to enter/update data) the form and sub-form. I added a Label on frmMain to display "Save" or "Edit" as the caption based on if I click the Save or Edit cmd buttons. It displays well, however, when I close the form and go back into it, the caption is cleared out. How can I get the caption to stay with the entry that I saved it with?
Also - when I re-open the form, the form displays the very first entry. How can I get it to display the most current record?
Thank you