Hello everyone,
I don't understand why this happens - please help!
I have a form to look up customer info. The form has a combo box where i can select a customer and it take me to the record via vba, something like this
Me.FilterOn = False
Me.RecordsetClone.FindFirst "[acct] = " & Me![Combo890]
Me.Bookmark = Me.RecordsetClone.Bookmark
Just today i added a search button next to the primary contact field which lets my users search for a contact only to filter the form. the code for that button uses the filter and works great.
the problem i found is if they use the filter and then go to use the combobox the filter remains on and the combobox wont work, so i added as you can see above, a filteron = false, however now it take 2 uses of the combobox to find the chosen record because the first time it seems to only turn off the filter - why is that?
if i select from the combobox a second time, it works fine since the filter is off. do i need to add something to the code to make it turn off the filter and then finish the rest of the code ???
thanks for any suggestions
I don't understand why this happens - please help!
I have a form to look up customer info. The form has a combo box where i can select a customer and it take me to the record via vba, something like this
Me.FilterOn = False
Me.RecordsetClone.FindFirst "[acct] = " & Me![Combo890]
Me.Bookmark = Me.RecordsetClone.Bookmark
Just today i added a search button next to the primary contact field which lets my users search for a contact only to filter the form. the code for that button uses the filter and works great.
the problem i found is if they use the filter and then go to use the combobox the filter remains on and the combobox wont work, so i added as you can see above, a filteron = false, however now it take 2 uses of the combobox to find the chosen record because the first time it seems to only turn off the filter - why is that?
if i select from the combobox a second time, it works fine since the filter is off. do i need to add something to the code to make it turn off the filter and then finish the rest of the code ???
thanks for any suggestions