True/False problem

[Danryan]

Hi, I am currently having a problem getting a true/false
value from a table based on the values in the two other fields.
My three fields are in the table are client names, boxno, missing (which is true/false). I have a combo box with clients names which after update affects a listbox contents (boxno). Sometimes this listbox contains more than one value (a client may have >1 file). Depending on which value of this listbox the user clicks on, I want the database to tell me whether or not this file is missing (ie true / false for that particular record).
Please help!

 

[Mile-O]

In the query that populates the Listbox add an extra column to take into account the Missing field.

On the AfterUpdate() event of the listbox, you can then refer to the extra column:

ie.

If Me.lstBox.Column(1) Then
    MsgBox "It's missing."
Else
    MsgBox "Don't worry; it's still here."
End If

 

[Danryan]

Thanks for your help, but I don't think that will work as I am not using any queries currently. Also the boxno can be true AND false as the box usually holds more than 1 file of a client. Thats why I need to check the client name AND the boxno to see if it is missing.

If you are misunderstanding me, I can post the code I have used so far? Thanks