Message Box Macro

[proulxsa]

I am trying to create a macro that will display a message if another record has the same information (ie. ***Top Priority*** has been selected for 2 different projects). I want it to warn the sales guys that someone else has assigned an analysis Top Priority and they should come see me to plead their case for Top Priority.

I know that I should have the macro run a query to find records with Top Priority, but how do I get the message to appear only if there is already another record with a Top Priority

Thanks

 

[jwindon]

I haven't used macros in quite a while, but I truly don't think that the option to do what you want to do is available.

What you are trying to accomplish could be used in VBA by utilizing functions such as DCOUNT. There is information in HELP to assist you. If you get stuck, post back in the Forms or VBA forum.

Good luck!

 

[proulxsa]

I finally did manage to get it to work with macros. I used the DCount as a condition for the MsgBox. My biggest problem was that I had my fields reversed in the formula.