G
Guest
I have a drop down box on a continuous form. My query is as follows:
SELECT Projects.*, Projects.Proj_CustomerID
FROM Projects
WHERE (((Projects.Proj_CustomerID)=[Forms]![To Do List - All Active
Items]![To Do_CustomerID]));
The problem I have is that when I use the drop down box for the after the
first time, the where criteria seems not to update.
For example, if the drop down box is used a customer ID of "Mickey", the "To
Do_CustomerID" part of the where clause displays only items associated with
customer "Mickey" from there on out, even if I am on a different customer
record.
If I exit the form, and select a customer of "Mouse", then all all subseqent
drop downs show "Mouse".
Any ideas - This one has to be a simple one you would think!!
SELECT Projects.*, Projects.Proj_CustomerID
FROM Projects
WHERE (((Projects.Proj_CustomerID)=[Forms]![To Do List - All Active
Items]![To Do_CustomerID]));
The problem I have is that when I use the drop down box for the after the
first time, the where criteria seems not to update.
For example, if the drop down box is used a customer ID of "Mickey", the "To
Do_CustomerID" part of the where clause displays only items associated with
customer "Mickey" from there on out, even if I am on a different customer
record.
If I exit the form, and select a customer of "Mouse", then all all subseqent
drop downs show "Mouse".
Any ideas - This one has to be a simple one you would think!!