Filter by subform's field values

[June7]

Does removing some records reduce enough? Delete some objects (reports and forms?) not involved in issue?

[Gina Maylone]

smallquickquotepro1 (2).zip Yes! Here it is June. Thank you! Was getting ready to chuck the whole thing!

[June7]

I am getting compile errors on the API Function and Sub declarations because I have 64-bit computer. Your profile says 64-bit and you don't get error? I had to modify with PtrSafe parameter.

[Gina Maylone]

I'm 64 bit - but I am not getting those errors.

[June7]

The subform is linked to main form on ContactID fields. The subform can only show records that are associated with the current main form record. If you make selections in the filter controls that are not valid for the current record, the subform will not return records.

So, what would be valid selections for contactID 5 that should return record(s)?


One approach is to have the filter controls only list choices that are valid for the current record.

[orange]

Just saw your post. I downloaded the file and can open it without error. I'm running 64 bit 8.1 with Access 2010 32 bit.
I notice you have code to log error, but have not set up table (tlogerror) to record them.

[June7]

Oh crud! So what is it about my computer that I need the PtrSafe parameter??????

[Gina Maylone]

Right, that's why I was questioning the possibility on the front end. However, I can run a query and get the records I want (with criteria based on the subform). So its back to the drawing board I guess. Thank you June.

[June7]

Okay, what query (bidfilterquery ?) and what criteria?

The Comand230 Click code is using the Me. reference. This means it is trying to apply filter to the main form, not the subform.

The double click is setting subform RecordSource to the bidfilterquery.

I NEVER use dynamic parameterized queries.

[Gina Maylone]

I removed the table to be able to shrink the db far enough to upload.

[June7]

What table? Why delete table? Delete data. If table is involved in the issue, how can we analyze without it?

Guessing I edited my previous post while you were reading. Might review again.

Really need to answer questions and provide requested info.

[Gina Maylone]

Query16 works. Ok - I see what you're referring to - so I changed it to:

 [
Forms]![contacts]![bidsheet].Filter = strWhere
        [Forms]![contacts]![bidsheet].FilterOn = True

And got the error, "Object doesn't support this property or method"
Me.bidsheet.filter=strwhere didn't work either.

[June7]

Still don't know what parameters to test with.

I would use:

Me.bidsheet.Form.Filter = strWhere
Me.bidsheet.Form.FilterOn = True

[Gina Maylone]

Test with status=Needs Bid. Or try Bidder=John Doe.

[June7]

In the posted db for Command230 Click event, you reference variable strFilter but the variable is strWhere