List Box Question

[ddrew]

On a form I have a list box that gets its information from a query. One of the fields in the query is 'Allocated'. and is a yes/No box. Double clicking on the entry on the form will alocate that entry to a textbox on my form. I then want the record to be removed from the list, hence I have a Yes/No field. Is there a double click event that will do this for me. Im not sure how to go about it.

 

[ErikSnoek]

Could you post the query behind the listbox and the code you currently have on the double click event.

 

[ddrew]

Basicly what Im saying is I want the record to be removed from the list once I have allocated it to a textbox!

 

[ddrew]

The query is:

Name, Grade, Allocated, allocated is a True/False box

Me.Text341 = Me.Competitiors

Competitors is the name of the listbox

 

[KenHigg]

The query that provides the rowsource for the list needs to limit the rows based on whats in the the text box. Basically something like show me all the rows where the field does not equal what is in the text box.

 

[ddrew]

UM Right. Thanks Ken, I probabley need to explain a little more. The DB is for a knockout competition, so there are a number of Textboxes, next to each textbox I have a radio button, depending which radio button is selected double clicking on a record in the list box will assign that record to the appropriate textbox.

As I say, once its been assigned to a textbox I need the list to update to only show those that are left to still be assigned.

 

[KenHigg]

Sorry, I'm kind lost on this one. If you can post a sample db that may help -

 

[ddrew]

Couldnt get the DB small enough, but a picture paints a thousand words, hopefully it gives you the idea. As I said Double clicking on a name puts it into the allocated textbox which is allocated by the radio button, Thanks!

 

[ddrew]

Sorry forgot to attach it