I have a text box where the user enters part of a number. the subform show all record that have part of that number. The combo box show all source of figures associated with that part number. The problem is when I make a selection with the combo box it disregards the text box and shows me all items with that source of figure.
How do I keep the combo box from requerying the selection? I tried to use the code below but I'm getting "method or data member not found" on .RowSource.
How to I fix the error or is there a better way of doing this?
How do I keep the combo box from requerying the selection? I tried to use the code below but I'm getting "method or data member not found" on .RowSource.
Code:
Private Sub CbSourceFig_AfterUpdate()
With Me.txtNSP
If IsNull(Me![Source of Fig/Item Numbers]) Then
.RowSource = ""
Else
.RowSource = "Select [NSP]" & _
"from Master_Totals_Search_qry " & _
"Where [SourceFig]=" & (Me.CbSourceFig)
End If
Call .Requery
End With
End Sub
How to I fix the error or is there a better way of doing this?