ACCESS FEED: Re: [MS_AccessPros] Help with textbox in a form

Jumat, 21 Juni 2019

Re: [MS_AccessPros] Help with textbox in a form

hi Kat,

on the form BeforeUpdate event, assuming 'docrev' is your fieldname or controlname, put this code:

me.docrev= nz(me.docrev, 0) +1

have an awesome day,
crystal

On 6/21/2019 12:02 PM, ka0t1c_ang3l wrote:

Hello!

I'm a novice with Access, and I need help with a textbox in a form.?? The form is used to make edits to a record, and what I want is to have the docrev textbox updated each time a record is edited.?? How would I go about doing that.?? Right now the box has a default value of 1; however, when I go in to make a change, I want the textbox to automatically update to 2, and so on.

Any help is greatly appreciated!

Thanks.

Kat