Code for Pop Up Box

I’m using Access 2002 and want to add a pop up box that will give information
when a combo box is clicked. Can anyone tell me what code I should use?

On Wed, 20 Dec 2006 08:27:01 -0800, Minnie M wrote:

I¢m using Access 2002 and want to add a pop up box that will give information
when a combo box is clicked. Can anyone tell me what code I should use?

To open a form and have everything wait until the form is closed:
DoCmd.OpenForm "FormName", , , , , acDialog

or if you just wish to display information, you could use a MsgBox:

MsgBox "This is some information."

--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail

Hi Fred, I think a message box may be what I need. The combo box is a list of
months, each month associated with a different town. So, I need to inform the
user which month he should select. Would a message box pop up when the user
clicks on the combo box, I don’t need to have it displayed permanently. Also,
how do I make a message box?

"fredg" wrote:

On Wed, 20 Dec 2006 08:27:01 -0800, Minnie M wrote:

Iʼm using Access 2002 and want to add a pop up box that will give information
when a combo box is clicked. Can anyone tell me what code I should use?

To open a form and have everything wait until the form is closed:
DoCmd.OpenForm "FormName", , , , , acDialog

or if you just wish to display information, you could use a MsgBox:

MsgBox "This is some information."

--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail

On Thu, 21 Dec 2006 02:07:00 -0800, Minnie M wrote:

Hi Fred, I think a message box may be what I need. The combo box is a list of
months, each month associated with a different town. So, I need to inform the
user which month he should select. Would a message box pop up when the user
clicks on the combo box, I don’t need to have it displayed permanently. Also,
how do I make a message box?

"fredg" wrote:

On Wed, 20 Dec 2006 08:27:01 -0800, Minnie M wrote:

Iʼm using Access 2002 and want to add a pop up box that will give information
when a combo box is clicked. Can anyone tell me what code I should use?

To open a form and have everything wait until the form is closed:
DoCmd.OpenForm "FormName", , , , , acDialog

or if you just wish to display information, you could use a MsgBox:

MsgBox "This is some information."

--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail



If you just want to display information, code the AfterUpdate or the
Click event (which one depends upon what you are doing) of the combo
Box:

MsgBox "What do you want to say here."

If you wish to give the user a choice of options and react to the
choice selected:

If MsgBox("Add this record to the table?",vbQuestion + vbYesNo) =
vbYes Then
' Add the record here
Else
' Do something else here
End If

Please look up MsgBox in VBA help.

--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail