Where condition on Combobox

[MunroeM]

I have a table (TemmisTagT) that has 175 records and the last field is a yes/no field (SignedOut). On my form i have a combo box that i use to look up the records. Now is there a way to modify/add to the following code so only the records that are Not checked show up in the list? I know i can do it by making a new Querry but im just wondering if i can do it with a extra bit of code thats already there.

Private Sub Combo120_AfterUpdate()
On Error GoTo Combo120_AfterUpdate_Err
    DoCmd.SearchForRecord , "", acFirst, "[TemmisTagNum] = " & "'" & Screen.ActiveControl & "'"

Combo120_AfterUpdate_Exit:
    Exit Sub
Combo120_AfterUpdate_Err:
    MsgBox Error$
    Resume Combo120_AfterUpdate_Exit
End Sub

Thanks

Munroe

[pbaldy]

If you want to affect the records that show up in the list, you need to change the row source. Modifying this will not affect what's in the list.

[MunroeM]

Of course... perfect thanks
i got it working now

[pbaldy]

Happy to help.