I have created a form with two combo fields.

When you make a selection from the first field, the drop down list in the second field is limited by a query based on the first combo selection. The second combo queries like:

SELECT TblGrant.GrantID, TblGrant.GrantTypeID, TblGrant.GrantSubType FROM TblGrant WHERE (((TblGrant.GrantTypeID)=Forms!FrmWorkPlan!GrantTy pe));

and GrantType is the pick in the first combo.

I have also coded:

Private Sub GrantType_AfterUpdate()
    Me.GrantSubType = Null
    Me.GrantSubType.Requery
    Me.GrantSubType = Me.GrantSubType.ItemData(0)
End Sub

Private Sub Form_Current()
    Me.GrantSubType.Requery
    Me.ProjectName.Requery

End Sub

All works well except when I try to filter by form. The first combo works as expected but the second combo does not requery.

I have looked at several examples in the MicroSoft library - none of them will update the second combobox in filter by form either. I do not know how to force the second combo to requery in the filter by form situation.

Perhaps one of you has some thoughts on this topic??

I wonder if it does not requery only for specific records. I.e. Perhaps the record you have filtered to has a value for GrantSubType that isn't valid based on the GrantType and therefore the Select for the second combo doesn't allow a value to display for GrantSubType. Make sure that the code doesn't work at all when you're filtering. Make sure that the GrantSubType is valid in combination with the GrantType. Also make sure that your filter by form doesn't specify a filter with an invalid GrantType/GrantSubType combination. That could be restricting the display.

Randall J Weers
Membership Vice President
Pacific NorthWest Access Developers Group
http://www.pnwadg.org