Re: Getting a subform to Show All records

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

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


.

Relevant Pages

  • RE: Child control is changing data on exit, how to stop?
    ... The subform has Office Name as the link child and master fields. ... Does not position the form to the selected doctor? ... what else do I have to add to get this cbo to filter the subform ... The net effect is the bound control only changes when the record changes, ...
    (microsoft.public.access.forms)
  • RE: Child control is changing data on exit, how to stop?
    ... The subform has Office Name as the link child and master fields. ... Does not position the form to the selected doctor? ... what else do I have to add to get this cbo to filter the subform ... The net effect is the bound control only changes when the record changes, ...
    (microsoft.public.access.forms)
  • Re: IsLoaded compliance error
    ... The records on the subform would remain the same. ... "Gina Whipp" wrote: ... icon in the toolbar which says "filter by selection" when hovering over ... The frmInvoices and frm Clients were in a book I was trying to learn ...
    (microsoft.public.access.formscoding)
  • RE: Child control is changing data on exit, how to stop?
    ... The subform has Office Name as the link child and master fields. ... Does not position the form to the selected doctor? ... what else do I have to add to get this cbo to filter the subform ... The net effect is the bound control only changes when the record changes, ...
    (microsoft.public.access.forms)
  • RE: Child control is changing data on exit, how to stop?
    ... The subform has Office Name as the link child and master fields. ... Does not position the form to the selected doctor? ... what else do I have to add to get this cbo to filter the subform ... The net effect is the bound control only changes when the record changes, ...
    (microsoft.public.access.forms)