If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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 |
Thread Tools | |
Display Modes | |
|
|