using a text box to filter through a list

[chrisse]

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.

[Darryl Kerkeslager]

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

[chrisse_2]

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