Checkbox to show/unshow data help

[2410Davie]

Hi Guys/Girls



Me again, this time I need help with my checkbox again, I got it sorted so that when checked it puts a date into the 'Issued Date' box and when unchecked it removes that date which works great now.

What I also want to do is when the check box is unchecked is to show a text box that says "Available" and when checked this is not visable, the reason is when a box is checked it means keys have been handed out and when returned its unchecked and they then become available again. I have managed to get it to show and hide my text box based on the check box but the issue is when checked it shows the whole column for this text box and when unchecked it hides then all and not just for the one that the checkbox has been ticked/unticked for?? it works for the date part so dont know why it doesnt work for this?

This is what I have just now

Private Sub Issued_AfterUpdate()
If (Me.Issued) = -1 Then
Me.Issued_Date = Now()
Me.Text22.Visible = True


Else
Me.Issued_Date = Null
Me.Issued_By = Null
Me.Issued_To = Null
Me.Text22.Visible = False


End If
End Sub

thanks for any help

Davie

[2410Davie]

Solved I didnt have the field in the actual table DOH!! now its added it works great