displaying msgbox when condition in macro return false

[lamha]

I have a Search macro that search for records in a form after the user enters an Item_ID. It was like this:
Action: GoToControl
Argument: Control Name: [Item_ID]

Action: FindRecord
Argument: Find What: =[txtFinder]
The whole thing works find except that when the Item_ID is not in the table, there is an error msg, then you have to click Halt to stop it. How do you put a msgBox letting the user know that the item was not found?
Thanks a lot for any help.

 

[RpbertS]

okay I think this may help you along.
If fieldname = "" Or IsNull(Subprojects) Or IsEmpty(Subprojects) then
MSgBox("Item not found")
end if

HTH