Questions on the 'Event' Properties of a form

  • Thread starter Thread starter ZBC
  • Start date Start date
Z

ZBC

I am confused about what is meant by some of the Events:
On Exit
On Got Focus
After Update
etc.

Exit from what??? ... moving the cursor out of the the Textbox or
Exiting the record?
After Update ... the Textbox or the record?
I haven't the foggiest what 'On Got Focus' means?

I am using an expression like:
Me!CurrentReserve = Nz(Me!CurrentReserve, 0) + Nz(Me!ReserveChange,0)
in the 'On Change' Event of a Textbox. CurrentReserve is a table field
that is a Record Source for a Textbox.

At what point does the table actually get changed?

WHAT I WANT TO DO ... is to temporarily reuse (as a variable) the value
of the Table field 'CurrentReserve' that was in the field when I entered
the current record and to be able to use it in expressions (unchanged) -
until I move to the next record (using Navigation Buttons).

Does this make sense?
Any enlightenment would be appreciated!
 
First, click into the event on the properties sheet and press F1. This should bring up help on the event.

The events are for objects (controls, forms, reports, etc). Therefore, they apply to the object that the properties dialog box lists in its drop down box at the top of the dialog.

--
Wayne Morgan
Microsoft Access MVP


I am confused about what is meant by some of the Events:
On Exit
On Got Focus
After Update
etc.

Exit from what??? ... moving the cursor out of the the Textbox or Exiting the record?
After Update ... the Textbox or the record?
I haven't the foggiest what 'On Got Focus' means?

I am using an expression like:
Me!CurrentReserve = Nz(Me!CurrentReserve, 0) + Nz(Me!ReserveChange,0)
in the 'On Change' Event of a Textbox. CurrentReserve is a table field that is a Record Source for a Textbox.

At what point does the table actually get changed?

WHAT I WANT TO DO ... is to temporarily reuse (as a variable) the value of the Table field 'CurrentReserve' that was in the field when I entered the current record and to be able to use it in expressions (unchanged) - until I move to the next record (using Navigation Buttons).

Does this make sense?
Any enlightenment would be appreciated!
 
Wayne,
I thank you for reminding me of how to get help on specific issues!
Believe it or not, I have been using 'search' on topics and have not
been particularily successful at finding what I am looking for.
I had forgotten the F1 key ... senior moment!
Thanks Again!
Bob
 
Back
Top