Please help with MsgBox in the Conditions

[CAP101]

I have a list box in my macro that does this if its Null: MsgBox("Do you want all sizes?",4,"Size")=7 I want the macro to ignore this if the listbox is NotNull but I can't figure out how to do that. Any help would be much appreciated!!

 

[pdx_man]

Are you trying to assign a value to a mesage box? =7

Are you using the conditions column in the macro testing for a null value?

Is this being called from a Form or Report?

Need some more info to help you.

 

[CAP101]

This macro is being called from a form and I am using the conditions column to test for a null value. If the combobox on my form is null, I want the msgbox to run but if there is a value in the combobox on the form, I want the macro to ignore the line: MsgBox("Do you want all sizes?",4,"Size")=7. That line is in the conditions column of the macro but it runs no matter whats in the combobox on the form. Not sure if I've explained myself properly or not. I'll try to give more information if thats not enough.