MsgBox function

[dcarr]

Does anyone know how to create a message box function based on the value of a column within a table.
I want to create one within the criteria field of a SELECT query that checks whether the count is greater than one, and if it is displays a message bx informing the userof the actual figure, and the actions they can take ok, cancel, etc.

criteria count > 0 MsgBox.................

I am really stuck!!! Thanks guys

 

[RV]

Use the DCount Function in VBA.

Search the forum for DCount, Message Box,..
There are lots of similar questions to be found, I'm sure you'll find your answer.

RV