I know that this was working just a few days ago and I haven't been anywhere near this part of the form recently but now it's not working correctly and I can't figure it out.
It's a basic cascade. The selection from one box dictates what is displayed in the box below.
However for some reason it's no updating properly and when I change the value of one record it changes the other records.....
This is for makes and models of trucks / heavy equipment.
For example if I select Chevrolet from the combo box 1 and then Silverado from combo box 2 it's all fine and dandy.
If I go to the next record and select Caterpillar from comb box 1 and then 401 from combo box 2 it clears the previous records model (Silverado).
Here's my row source for box 1:
Code:
SELECT DISTINCT Makes.MakeName, Makes.MakeID FROM Makes ORDER BY Makes.MakeName;
And then I also have an On Change VBA event:
Code:
Me!ModelName = Null
Me!ModelName.Requery
Here's the row source for box 2:
Code:
SELECT DISTINCTROW Models.ModelID, Models.ModelName FROM Models WHERE ((Models.MakeID) Like forms![Asset Details]!MakeName) ORDER BY Models.ModelName;
Does anything there stick out as the culprit?
TIA