Null value in row in listbox

[Ruegen]

I have a series of 5 columns in a listbox



I was hoping to null the value in column 5 for the selected row

so click on record 123 then makes record 123's column 5 value null

note* not the whole column - just the one clicked on.

To give an example I have:

strsql = "SELECT tblSchools.NewSchoolsID, tblSchools.SchoolName, tblSchools.SchoolSuburb, tblStates.SchoolState, tblSchools.ClusterID, tblSchools.AreaID, tblAreas.Area " & vbCrLf & _
"FROM tblStates INNER JOIN (tblAreas INNER JOIN tblSchools ON tblAreas.AreasID = tblSchools.AreaID) ON tblStates.StateID = tblSchools.StateID " & vbCrLf & _
"WHERE (((tblSchools.ClusterID)=" & Me.txtClusterID & ");"
Me.List0.Requery

in a listbox.

I have a text box where what ever number is the same as in txtClusterID shows in the listbox.

However I would like to clear whatever name is in that listbox by making the value of the row's clusterID null that way the form refreshes with one less.

[Ruegen]

Nevermind - going with a subform...