Creating a Macro to display a message box?

[eberry707]

Hello:

I am trying to create a Macro in Access 2003 that will only display a message if a certain field is marked yes.

For example, when you open up a form, I need a message box to automatically pop up as "UNEMPLOYED INDIVIDUAL" if the unemployed field within the underlying table is marked "yes".

Thoughts - Is a macro the best wat to do this?

Thanks

[MMcCarthy]

Hello:

I am trying to create a Macro in Access 2003 that will only display a message if a certain field is marked yes.

For example, when you open up a form, I need a message box to automatically pop up as "UNEMPLOYED INDIVIDUAL" if the unemployed field within the underlying table is marked "yes".

Thoughts - Is a macro the best wat to do this?

Thanks

In the form open event ...

Private Sub Form_Open()
 
   If Me!Unemployed = "Yes" Then
      Msgbox "UNEMPLOYED INDIVIDUAL", vbOkOnly
   End If
 
End Sub
 

Mary

[eberry707]

Thanks for the information. I am not too familiar with writing code, and there was an error when I attempted to add it.

Is there a way to set this up from an expression or a macro without having to actually "write code"?

Thanks

Eric

[maxamis4]

The anwser is yes. I don't recommend Macros at all. There excellent tools, but I would really recommend to do the code bit. As for the macro answer:

1. create a new macro
2. Click on the Condition button located in your tool bar.
3. Create the condition, such as forms!form1!text1 = true
4. Select Action msgbox and type in the message.
5. Goto the form, and under the event "On Open" select the macro you want to use.

Good luck

[Geneman]

You don't need a Macro.

Just put the suggested code in the OnCurrent part of the form


Private Sub Form_Current()
If Me.unemployed = "Yes" Then
MsgBox("Unemployed Individual", vbokonly)
Endif
End Sub

I think that syntax is correct.