Popup box

[Rebecca]

I hope I get the same response as I did with my last question. It was so
quick.. THANK YOU!

In my database I have members that become suspended. Currently they are in
the main table but there is a column that contains an "X" if they are
suspended. (I did not design the database, I am now in charge of it.. I was
thinking of changing this to a yes/no check box) But what I would like is
when someone searches for records in my Member Form I want a box to pop up,
(if possible a big box, my boss is 77 and she doesn't pay attention to the
box I have on the form that shows the X for suspended) that says "this
member is suspended".

Again, any help would be greatly appreciated!

Thanks in advance.

Rebecca S.

 

[admin]

This is a little tougher but I got it.

Don't use a pop window, just create a empty unbound text box. Then make
it's Control Source equal to this:

=IIf([nonmember]="x","This member is SUSPENDED","")

You can format the text box with a big colored font.

(Note: of course change [nonmember] to the correct field name.)

 

[Pavel Romashkin]

I think you should change the design to use a more efficient Yes/No type field.
As far as a popup box goes, try putting the code below in the Current
event of the form:

IF InStr(1, Me!Suspended, "x", vbTextCompare) <> 0 THEN MsgBox "THIS
MEMBER IS SUSPENDED!"

After you change it to a Yes/No type it will be even easier:

IF Me!Suspended THEN MsgBox "THIS MEMBER IS SUSPENDED!"

Cheers,
Pavel

 

[charlieo]

One way I can think of is to create a Macro. In the Macro
state that if ControlName = "X" then display a message
box. In that message box enter the Text Desired.

In the form design view in the 'on open' control call the
Marco.

The message box will pop up anytime an 'x' appears in the
suspended box.