[AccessD] Requery a query

The answer may well depend on how you retrieve the value the first time around. Can you post the SQL/code?

Lambert 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Dale_Anne Kalsow
Sent: Thursday, May 20, 2010 12:18 PM
To: Access Developers discussion and problem solving
Subject: [AccessD] Requery a query


Good Morning,
 
I have a query that supports a combo box.  Part of the underlaying query gets a value from a label on its form.  The query works great when the form is open - it returns (uses) the correct value.  My problem is when I change the value stored in the label (through code) and tell the combo box to do a requery (me.Combo0.Requery).  It does it but the new value of the label is not used but rather what the data was in the label when the form was reopened.  
 
Does anyone know how to tell the combo box's query to go and reread the value in the label?
 
thanks!
 
Dale


      
--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com