By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
428,839 Members | 2,270 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 428,839 IT Pros & Developers. It's quick & easy.

using a text box to filter through a list

P: n/a
Hey,

I'm having quite a bit of trouble trying to filter through a list
using a text box and multiple combo boxes. When you write anything in
the text box the list goes blank. Although when you select something
from one of the combo boxes nothing happens at all.

Help will be greatly appreciated.
Nov 13 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
On 20 Feb 2005 21:00:01 -0800, chrisse <ch*******@hotmail.com> wrote:
I'm having quite a bit of trouble trying to filter through a list
using a text box and multiple combo boxes. When you write anything in
the text box the list goes blank. Although when you select something
from one of the combo boxes nothing happens at all.


The list goes blank because of event code that you have written. Nothing
happens when you update the combo box because there is code in the After
Update event that you have not written. If you could post the code from
both ...
Darryl Kerkeslager
Nov 13 '05 #2

P: n/a

Darryl Kerkeslager wrote:
On 20 Feb 2005 21:00:01 -0800, chrisse <ch*******@hotmail.com> wrote:
I'm having quite a bit of trouble trying to filter through a list
using a text box and multiple combo boxes. When you write anything in the text box the list goes blank. Although when you select something from one of the combo boxes nothing happens at all.
The list goes blank because of event code that you have written.

Nothing happens when you update the combo box because there is code in the After Update event that you have not written. If you could post the code from both ...
Darryl Kerkeslager

Thanks so much, here it is:

Private Sub Description_Change()

SendKeys "+~", True

DoCmd.RunCommand acCmdSaveRecord

If Me.Details.ItemsSelected.Count = 0 Then

SearchProc

Else

EditProc
End If

DoCmd.GoToControl "Description"
Me.Description.SelLength = 0

SendKeys "{end}", True

End Sub

Private Sub Details_AfterUpdate()

DetailVar = Me.Details

LoadSentinel = False

DetailSelectedVar = 0
Call RefreshFormProc(DetailVar)

End Sub

I think thats what you'll need.

Thanks again

Christina

Nov 13 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.