Macro condition not being executed, even when met

•

What is DaniWeb IT Discussion Community?

You're currently browsing the MS Access and FileMaker Pro section within the Web Development category of DaniWeb, a massive community of 429,897 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 2,385 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.

Join our community!

Please support our MS Access and FileMaker Pro advertiser: Programming Forums

Thread Tools Display Modes

Views: 608 | Replies: 0

•

Join Date: Apr 2008

Posts: 48

Reputation: helraizer is an unknown quantity at this point

Rep Power: 1

Solved Threads: 3

helraizer

Offline

Light Poster

Macro condition not being executed, even when met

May 16th, 2008

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:

Help with Code Tags

(Toggle Plain Text)

  
      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