Query database before finalizing report

Comments

• gordk St.Catherines On. Canada.

  November 2013 edited 5:56PM

  use dialog form enter and open the query dataset after exiting the memo control and see if there is a record count
  if none set the mrok button to false and show a message.
• gordk St.Catherines On. Canada.

  November 2013 edited 5:56PM

  You might also take a look at the main demo underdialog and scripts
  at the choose records to print demo for another idea.
• DavidWIII

  November 2013 edited 5:56PM

  Thanks, gordk. That works perfectly for my report in the OnChange event by keeping the OK button disabled.
  Now I'm trying to verify if the number exists in a date range. A start date and end date are entered in DateEdit controls. Querying the database each time the user scrolls through each calendar might be too much, so I am trying the OnExit event for those controls. The problem with that approach... exiting one control to change the other can cause a message to pop up.
  
  Is there a way to query the database after the user clicks the mrok button, and then stop the report from running if there are no results from the query? I am guessing there is not.
  
  Your answer is still helpful, and I'll still come up with a workable solution regardless.