After Update Question

[Bob]

I have a Combo Box that has 3 options in it about tax , Can I add a Message
box to warn about something , so you click OK and carry on selecting your
choice, There is nothing On Click just After Update

Thanks in advance.........Bob Vance

 

[Sarah Schreffler]

I have a Combo Box that has 3 options in it about tax , Can I add a Message
box to warn about something , so you click OK and carry on selecting your
choice, There is nothing On Click just After Update

Thanks in advance.........Bob Vance

If you want the Msgbox to offer the option NOT to select the option,
then you want BeforeUpdate instead. (That can be cancelled)

AfterUpdate fires after the choice is made.

Sarah Schreffler

 

[Bob]

No just wanted to give them a warning when they click on the arrow but still
proceed...Thanx Bob
OK Warning that they have read it!

 

[Svetlana]

You could raise up the msg box you want on mouse down event for the
combobox.

 

[Bob]

Could you alter this message so it works...Thanx Bob

Private Sub cbGSTOptions_MouseDown(Button As Integer, Shift As Integer, X As
Single, Y As Single)
"Please Update Your Tax Button"
End Sub

 

[Sarah Schreffler]

Could you alter this message so it works...Thanx Bob

Private Sub cbGSTOptions_MouseDown(Button As Integer, Shift As Integer, X As
Single, Y As Single)
"Please Update Your Tax Button"
End Sub

Okay, BeforeUpdate and AfterUpdate doesn't fire until after they have
made a choice in Combo Box.

In order to pop up a MSgbox you need to use the command.

Msgbox "Please Update Your Tax Button"

 

[Bob]

Thanx Sarah worked brilliant....Access doesn't have a Mouse over message
does it , Cursor over box and a message pops up.....Thanks bob

 

[Sarah Schreffler]

Not a Mouse Over message.
But the ComboBox (in Access 2003) DOES have a OnMouseMove event. II
have not worked with it (didn't even know it was there until you asked
and I went to look) You might take a look at the help on that and see
if it would suit.

The way Access generally works (like Visual Basic) is actions
triggering events. Then you can write code (or macros but generally
VBA code is a better idea, more flexible, ability to step through the
code to find errors and catch errors gracefully) to run when an event
is trigger. For example, changing the status line or popping up a
message box when the mouse moves over a particular control

Sarah Schreffler

 

[Bob]

What have I done wrong here, I want to show this message:
Private Sub tbCompanyName_MouseMove(Button As Integer, Shift As Integer, X
As Single, Y As Single)
Msgbox(This is a Company Name Box)
End Sub

 

[Bob]

I am Stupid
Msgbox("This is a Company Name Box")

What have I done wrong here, I want to show this message:
Private Sub tbCompanyName_MouseMove(Button As Integer, Shift As Integer, X
As Single, Y As Single)
Msgbox(This is a Company Name Box)
End Sub