helraizer 1 Light Poster

Hi folks,

I have a system for an auctioneer and have on the form I have the fields: lot (the item), reserve price ([Reserve]) and minimum successful bid so far ([Min]). There is then a text box for the user to input their bid ([Bid]). I have set up a macro for this:

mcr_addBid:
  
      Condition               Action           
  
      isNull([Lot])           MsgBox
  
      isNull([Lot])           Stop Macro
  
      isNull([Bid])           MsgBox
  
      isNull([Bid])           StopMacro
  
      [Bid]<=[Reserve]    MsgBox
  
      [Bid]<=[Reserve]    StopMacro
  
      [Bid]<=[Min]          MsgBox
  
      [Bid]<=[Min]          StopMacro
  
      [Bid]>[Min]            MsgBox
  
      [Bid]>[Min]            StopMacro

at the moment I've only set it up for msg boxes to test it, but it works fine if either Lot or Bid is empty but then any value in bids doesn't run any of the latter actions, it's not that it gets stuck on one, it doesn't do any of them at all.

Am I doing something wrong with the conditions? (I obviously am doing something, but I don't know what).

Thanks,
Sam