From: HarvestWind@comcast.net   
      
   Hi:   
      
   I'm running a simple query on an Access Table from VB6.0.  The operator can   
   make several different selections.  Based on their selection, a different,   
   specific SQL needs to be run.  So, when the operator says... "Do it"...the   
   click procedure goes to a Function (based on their selection)...the specific   
   function builds the correct SQL and returns it...then it sends that query to   
   the final procedure to run the sql, retrieve the data and put it on my form.   
   When I run the program, it returns the data in the first three fields, but   
   the fourth field is empty...there is data in that field in the table...but   
   it is not returned.  I've checked the SQL that is being passed and it is   
   being passed correctly.   
      
   When I put a "MsgBox SQL" to check out the SQL (after the SQL is developed   
   and before it is actually run in the final procedure) the SQL is correct and   
   all of the data is printed on the form (that is when the program pauses and   
   waits for the operator to click on the message box).  When there is no pause   
   for a message box, the data is not returned...when them message box is   
   there, the data is returned correctly.   
      
   CAn anyone tell me what the heck is happening?  And how I might get around   
   this without having the operator read and close a message box?   
      
   Any assistance or suggestion would be helpful.   
      
   JP   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)