Search results

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...

When you select type 1, then select type 3, it returns a subset of type 1 records.

You originally said there were no Type 3 records? Yes. There still aren't. Run manually, the query returns the correct set of records for Type 3: a null set.

I have checked the value of [Tempvars]![TV_Pricing_TypeTrip] while debugging. The RecordSource query should be preventing any records with TypeTrip = 2 from being displayed when "Timber to Mill" is selected. As you can see above this isn't working. However, running the same query manually...

Yes, I understand that. The problem is that the criteria in the recordsource is not properly limiting the records being allowed through, in one case. In terms of what tool to use to limit the records being displayed, in this case I use a combination of query criteria and filters.

arnelgp, could you please say what you mean by a "filtered query"? The form recordsource query is just a query that includes a WHERE clause. The WHERE clause is what I meant when I said the query was intended to provide a filter.

It's based on a query with a WHERE clause that uses a tempvar set by the form. Form filters are set in VBA. However, they do not target the column that's used in the query's WHERE clause.

The code that affects the RecordSource query is posted above. Why not apply filters? It's six of one, half a dozen of the other. The value is being set correctly. Opening the RecordSource query manually while the form is open with "Timber to Mill" is selected returns the right results...

There is no subform. The afterupdate code is pretty long. Here is are the lines directly related to this issue: Private Sub grpTypeTrip_AfterUpdate() SetValuesForCurrentTypeTrip End Sub Public Sub SetValuesForCurrentTypeTrip() TempVars!TV_Pricing_TypeTrip = grpTypeTrip.Value . ...

Hello All, I am developing a continuous form for a timber yard, using Access 2016. The form manages pay rates for carriers of loads of timber products. There are three basic types of journeys these carriers can make: from a remote timber source to my client's yard; from my client's yard to a...

Hello All. I'm an Access developer from the US. I started doing Access development in 1996. Prior to that I was a programmer dating back to the days of source decks. I have used Access as an employee, contractor and now am a semiretired part time freelancer (via UpWork). I still do things...