Form Question

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Someone told me to put some code in the "after update event check box". I
have absolutely no idea where this is, can someone please help me out.

Thank you
 
With the form open in Design mode, select the check box. Ensure that its
Properties dialog box is open (select Properties from the View menu, or
right-click on the selected check box). Choose the Event tab in the
Properties box. Find the entry named "After Update" on that tab. In the
white space to the right of it, select [Event Procedure]. Click on the
ellipsis (...) to the right of that, and you'll be taken in the VB editor,
in the correct spot in the form's module.
 
I don't have and After Update line, I have an On Focus. Can I use this?

Douglas J Steele said:
With the form open in Design mode, select the check box. Ensure that its
Properties dialog box is open (select Properties from the View menu, or
right-click on the selected check box). Choose the Event tab in the
Properties box. Find the entry named "After Update" on that tab. In the
white space to the right of it, select [Event Procedure]. Click on the
ellipsis (...) to the right of that, and you'll be taken in the VB editor,
in the correct spot in the form's module.

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)


metaltecks said:
Someone told me to put some code in the "after update event check box". I
have absolutely no idea where this is, can someone please help me out.

Thank you
Click to expand...
Click to expand...
 
Are you sure you've looking at the Properties for the check box? There
should definitely be an AfterUpdate event for the check box control.

Without knowing what you're trying to do, I can't advise you whether the On
Focus event can substitute. AfterUpdate means you've changed the value:
Focus means you've advanced to the check box, but doesn't mean that you've
changed its value.

--
Doug Steele, Microsoft Access MVP

(no private e-mails, please)


metaltecks said:
I don't have and After Update line, I have an On Focus. Can I use this?

Douglas J Steele said:
With the form open in Design mode, select the check box. Ensure that its
Properties dialog box is open (select Properties from the View menu, or
right-click on the selected check box). Choose the Event tab in the
Properties box. Find the entry named "After Update" on that tab. In the
white space to the right of it, select [Event Procedure]. Click on the
ellipsis (...) to the right of that, and you'll be taken in the VB
editor,
in the correct spot in the form's module.

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)


metaltecks said:
Someone told me to put some code in the "after update event check
box". I
have absolutely no idea where this is, can someone please help me out.

Thank you
Click to expand...
Click to expand...
Click to expand...
 
Back
Top