Reminder Note

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

Guest

I have a form with a combo drop down box. What I am looking to do is when a
particular value from the drop down box is selected a message appears that
tells them to do something.

For example if the drop down box had days of the week in, and Monday or
Friday was selected, a box would appear telling them to 'Bank all money by
1pm'.

Is this possible and simple to do?

Any help appreciated :)
 
For complete info go to VBA help and type Msgbox function.

Here is something I modified from Arvin Meyer

I'd use the After Update event of the form. Create an
[Event Procedure] which looks something like this
(aircode):

Sub Form_Current()
If Me.DayOfWeek = "Monday" Then
MsgBox "Your Message", vbOKOnly, "Today is Monday"
End If
End Sub

Chris
 
Cheers Chris, worked a treat !!

Many Thanks

Chris Reveille said:
For complete info go to VBA help and type Msgbox function.

Here is something I modified from Arvin Meyer

I'd use the After Update event of the form. Create an
[Event Procedure] which looks something like this
(aircode):

Sub Form_Current()
If Me.DayOfWeek = "Monday" Then
MsgBox "Your Message", vbOKOnly, "Today is Monday"
End If
End Sub

Chris
-----Original Message-----
I have a form with a combo drop down box. What I am looking to do is when a
particular value from the drop down box is selected a message appears that
tells them to do something.

For example if the drop down box had days of the week in, and Monday or
Friday was selected, a box would appear telling them to 'Bank all money by
1pm'.

Is this possible and simple to do?

Any help appreciated :)
.
Click to expand...
Click to expand...
 
Back
Top