Events

[brsawvel]

I have a form with 4 boxes:

Box 1 has one of 3 values in it.
Box 2 is a textbox.
Box 3 is a combobox.
Box 4 is a listbox.

The value in Box 1 determines which of Box 2-4 becomes visible.

I have the code written/tested already:

 If Me.Box1.Value = "A" Then Me.Box2.Visible = True

However, I'm not sure which event to put the code into so that the form resets as the user goes from one record to the next.

Can I get help with this.

Also, does anyone know of a good website to go to where the event types are described in simple terms for mongos like myself?

 

[DCrake]

Use the forms OnCurrent Event if it is a bound form.

You may also need to put it on the after update event of the first control.

David

 

[Banana]

Dcrake already gave you a great answer- Regarding the second question, there's actually an entry in the help file if you open VBA editor and type "events order" in the help search bar on upper right corner of the editor. It will tell you what order events fire and how it works. You also can ready the help file for all events (e.g. enter "BeforeUpdate event" to learn more about what it does, when it fires, etc) so you can determine if this is right event for what you need.