View Single Post
  #1  
Old May 12th, 2010, 01:51 PM posted to microsoft.public.access.forms
TR
external usenet poster
 
Posts: 28
Default Combo Box Filter

i have a form that is used for data entry. employees use the form to bring up
records. there are 2 combo boxes on the form to filter for specific records
in a Time Zone and particular Segment.

The underlying table as records - but 2 groups. Current and New.

I have a button on the form that can bring up the current group or the new
group. each are based on queries used as filters.
however, i only want employees to work on current group records.

the problem: when the employees are in the current group and use the combo
boxes for a specific time zone and segment the form shows both current and
new event though the current was filtered previously.

make sense? i don't know what i'm doing wrong. The event procedure for the
combo boxes is as follows and is on the AfterUpdate.
Option Compare Database

Private Sub Combo143_AfterUpdate()
Me.Filter = "[Segment Type] like '" & Me.Combo151 & "'" & " and [Time Zone]
like '" & Me.Combo143 & "'"

Me.FilterOn = True
End Sub

Private Sub Combo151_AfterUpdate()
Me.Filter = "[Segment Type] like '" & Me.Combo151 & "'" & " and [Time Zone]
like '" & Me.Combo143 & "'"

Me.FilterOn = True