J
jneseth
I have the following code that works as designed in Access2003, but does not
do anything in Access2007
If frm_LSO_change_quantity_flag1 < 5 Then
frm_LSO_change_quantity_flag1 = 10
answ1 = InputBox("Enter in the Part Number...).", "Search for Part
number")
Me.frm_LSO_change_quantity_sub1.Form.Filter = "[honeywell_part_number]
Like'" & answ1 & "*'"
DoCmd.RunCommand acCmdApplyFilterSort
Me.Command68.Caption = "View All"
Exit Sub
End If
I am using the 'Like' in the form filter that works as you would expect, the
person enters in a beginning text string and sets the form filter to anything
that starts with that string. However when running access2007, this filter
is non-operational.
Questions are, what do I need to do differently for the access2007 version,
and what enviromental variable do I need to look at that gives me the version
information??
Thanks for your help!
do anything in Access2007
If frm_LSO_change_quantity_flag1 < 5 Then
frm_LSO_change_quantity_flag1 = 10
answ1 = InputBox("Enter in the Part Number...).", "Search for Part
number")
Me.frm_LSO_change_quantity_sub1.Form.Filter = "[honeywell_part_number]
Like'" & answ1 & "*'"
DoCmd.RunCommand acCmdApplyFilterSort
Me.Command68.Caption = "View All"
Exit Sub
End If
I am using the 'Like' in the form filter that works as you would expect, the
person enters in a beginning text string and sets the form filter to anything
that starts with that string. However when running access2007, this filter
is non-operational.
Questions are, what do I need to do differently for the access2007 version,
and what enviromental variable do I need to look at that gives me the version
information??
Thanks for your help!