Try this in the AfterUpdate event procedure of the ComboBox:
Me.Filter = "[FieldName] = '" & me![ComboValue] & "'"
Me.FilterOn = true
Me.requery
The expression used above depicts a text value for the FieldName(note single quotes around combo value)
If Numeric field name value then use the following:
Me.Filter = "[FieldName = Me![ComboValue]"
This should get you close to what you want. Get back to me if you need more assistance. Bob Scriver
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.