|
-
filter a subform from a combo box
I'm new here so please consider me a novice at this. I have a combo box located on a switchboard with a subform on the same switchboard. I'm trying to filter the subform with a combo box. The combo box contains the numbers 01 to 20. The data it is filtering always contains the first two digits and that works well. My problem is that there are other numbers that may begin with the two digit code but has trailing characters, e.g., 18,1801,1810,180101 etc., and I want these items to show up when 18 is selected from the combo box.
The field that's being filtered is titled WBS
The combo box is combo216
Code to filter the two digit numbers is:
Private Sub Combo216_AfterUpdate()
DoCmd.ShowAllRecords
With Me.[CES_2009A_ENG SUBFORM].Form
Me.Filter = "wbs = combo216"
Me.FilterOn = True
End With
End Sub
Would really appreciate your help; thanks in advance
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|