From: nt_consulting64@yahoo.com   
      
   "Joe-Paul"  wrote in message   
   news:SdudnShigOOzG7jZnZ2dneKdnZydnZ2d@comcast.com...   
   > 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   
   >   
      
      
   I think we need to see some code.   
      
   It is doubtful your SQL is being affected by the msgbox, it has to be   
   something in how you are attempting to capture or view the value.   
      
   Because the returned values are variants, a msgbox can on occasion affect   
   displayed results by 'fixing' the value to a specific type. But that is   
   uncommon and just a wild suggestion on my part.   
      
   Review how you are capturing the values of that last field. Doing anything   
   cute?   
      
   -ralph   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)