Filtering between Forms. (1 Viewer)

[zocker]

Greetings to All! Thanks for my forum membership.
I have a problem with two forms:
Form 'Navigate' has a control to open another form - 'CompetitionOrganisers', That form Opens to show All records and a Subform to display rlated details. Any Organiser can be selected by a Combo...no problem.
On 'Navigate' i have a listbox to display a short list of particular records. A click on a particular Listbox choice opens the CompetitionOrgainsers to display a particular Organiser and its detail. All OK there.
But...when opened from the Listbox, the Combo on CompetitionOrganisers no longer functions. The Listbox 'sends' a Filter to Cokpetition organisers so that limits its recordset. I have tried all manner of Filter = False. Me.Recordset yet nothing works.

Thanks in advance for you ideas!

Zocker

 

[MajP]

I am assuming that the combo is unbound, and that it is not linked to the subform.
So what code exists now in the combo to navigate to a new record?
I would assume you need something like this in the combo after update

if not IsNull(Me.SearchComboName) then
  Me.filter = "someFieldID = " & me.SearchComboName
  Me.filterOn = true
else
  me.filter = ""
  me.filterOn = false
end if

The combo then filters the main form to the value selected in the combo

You are correct. If you open a form with
docmd.openform and apply a WhereCondition it passes that as a filter to the form and opens the form with a filter applied. So I do not know what you tried but you should have been able to remove the filter like you said you already tried.

 

[zocker]

I am assuming that the combo is unbound, and that it is not linked to the subform.
So what code exists now in the combo to navigate to a new record?
I would assume you need something like this in the combo after update

if not IsNull(Me.SearchComboName) then
  Me.filter = "someFieldID = " & me.SearchComboName
  Me.filterOn = true
else
  me.filter = ""
  me.filterOn = false
end if

The combo then filters the main form to the value selected in the combo

You are correct. If you open a form with
docmd.openform and apply a WhereCondition it passes that as a filter to the form and opens the form with a filter applied. So I do not know what you tried but you should have been able to remove the filter like you said you already tried.

Thanks for your reply! Z