How do i open a form and hide a field?

[xwnoob]

Currently i need to hide a listbox whenever i open a form. I think the best way to do this is to turn off the visible property.

This is my code:



Private Sub ShowCommitRecord_Click()


DoCmd.OpenForm "AddCommitmentDetail", , , "CommitmentID=" & Me.ListShowCommit.Column(3), , , "Edit"
DoCmd.Close acForm, "SelectEditCommitment"

End Sub
This is from a form where i select a record from a listbox and then open a form based on the selected record using a button.

I dont know what is the visible syntax so could anyone tell me how to turn off the visible property of a control using vba when opening the form?

[June7]

Probably easier to set the Visible property to No in the listbox Properties window. Then use code to make visible when condition requires it.