Problem with form filter (1 Viewer)

Talus

New member
Local time
Today, 04:11
Joined
Jan 16, 2021
Messages
11
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

Super Moderator
Staff member
Local time
Today, 11:11
Joined
Feb 19, 2013
Messages
16,553
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
 

Users who are viewing this thread

Top Bottom