Re: Getting a subform to Show All records

I don't think this is the root problem, Allan.

The database is in a filtered state - I can successfully filter using
cboMatrixName to display a record set iin the subform that matches the
combobox criteria.

I am unable to programmatically "unfilter" so that the subform displays all
records.

I've tried setting the FilterOn property of the Main Form and Sub Form to
False, and I've tried using a WHERE clause like this: "[MatrixName] LIKE
'*'" on both the Main Form and the Sub Form. Neither approach will Show All
of the records.

I'm accustomed to working in Excel VBA, and this is so easy to do
programmatically.
In Access, I feel like I'm tripping over myself.

I was researching this issue last night, and came across this posting by
Allen Browne:

"If a form and its subform are both filtered and you remove the filter from
the subform, Access no longer recognises that the main form is filtered. The
word "(Filtered)" disappears from the form's navigation buttons. It does not
show all the records, but attempting to turn off the main form's filter
fails, and falsely reports its FilterOn property is False." (see more at
http://allenbrowne.com/bug-02.html)

Maybe this is the root cause of my difficulties . . .

"ruralguy via AccessMonster.com" wrote:

Could it be that when you do a:
Me.ctrlSubForm.Form.Requery ' ctrlSubForm is the Sub-Form
...nothing appears to change on the SubForm because it is on the correct
record?

dsimcox wrote:
Yes - I can move to a different record on the Main Form, and doing so updates
the Sub Form.

As I asked earlier:
Can you move to a different record on the MainForm after you remove the
[quoted text clipped - 21 lines]

Is there a better way to "Show All" records in the subform?

--
RuralGuy (RG for short) aka Allan Bunch MS Access MVP - acXP WinXP Pro
Please post back to this forum so all may benefit.

Message posted via http://www.accessmonster.com


.

Quantcast