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

Bob wrote:
> 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

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!

"Sarah Schreffler" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
>
> Bob wrote:
>> 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
>

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

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

"Svetlana" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> You could raise up the msg box you want on mouse down event for the
> combobox.
>

Bob wrote:
> 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
>
> "Svetlana" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
> > You could raise up the msg box you want on mouse down event for the
> > combobox.

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"

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" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
>
> Bob wrote:
>> 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
>>
>> "Svetlana" <(E-Mail Removed)> wrote in message
>> news:(E-Mail Removed)...
>> > You could raise up the msg box you want on mouse down event for the
>> > combobox.
>
> 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"
>

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 wrote:
> 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" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
> >
> > Bob wrote:
> >> 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
> >>
> >> "Svetlana" <(E-Mail Removed)> wrote in message
> >> news:(E-Mail Removed)...
> >> > You could raise up the msg box you want on mouse down event for the
> >> > combobox.
> >
> > 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"
> >

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

"Sarah Schreffler" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> 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 wrote:
>> 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" <(E-Mail Removed)> wrote in message
>> news:(E-Mail Removed)...
>> >
>> > Bob wrote:
>> >> 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
>> >>
>> >> "Svetlana" <(E-Mail Removed)> wrote in message
>> >> news:(E-Mail Removed)...
>> >> > You could raise up the msg box you want on mouse down event for the
>> >> > combobox.
>> >
>> > 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"
>> >
>

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

"Bob" <(E-Mail Removed)> wrote in message news:e7kg0g$tfa$(E-Mail Removed)...
> 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
>
> "Sarah Schreffler" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
>> 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 wrote:
>>> 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" <(E-Mail Removed)> wrote in message
>>> news:(E-Mail Removed)...
>>> >
>>> > Bob wrote:
>>> >> 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
>>> >>
>>> >> "Svetlana" <(E-Mail Removed)> wrote in message
>>> >> news:(E-Mail Removed)...
>>> >> > You could raise up the msg box you want on mouse down event for the
>>> >> > combobox.
>>> >
>>> > 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"
>>> >
>>
>
>