Problem with form filter

[Talus]

Making the form RecordSource the pricing table rather than the query, and moving the TripType selection criterion to the form filter processing appears to have handled this problem.

Why the problem arose in the first place remains a mystery. My best guess is that it was caused by an Access defect in implementing filtering. It could have been form corruption, though I tried standard techniques for handling corruption (decompile, SaveAsText/LoadFromText). Of course it could still have been developer error, though I obviously don't know where. At any rate, thank you all for your help!

 

[CJ_London]

from your response in post#20, I would surmise that your code is either assigning the type before the change, or it is not assigning it at all so retaining the original value of 1 or 2.

I doubt it is an access defect, more likely developer error. Mixing criteria and filters may have been the issue which you have solved by just using filtering