macro conditional msgbox

[Z-Man]

The following MsgBox in a macro generates a Yes No condition
MsgBox("Question",36)=7
Can someone tell me what the "36" and "7" do?

 

[Steve Schapel]

Z-Man,

The 36 defines the Buttons parameter of the messagebox, in this case
4+32 where 4 is the code for Yes and No buttons, and 32 is the code for
a Question icon.

The 7 is the value returned by the MsgBox function, in this case No.
The code for Yes is 6.

For more details of these numerical codes, see Access Help for MsgBox
function.