Search results

I don't know what happened. I changed the relationships in my query attached to my form because I was getting a "one to many" error when I selected from a list box. I changed the relationship to go from "ID" to "ID" and now I can't type in the form at all. Help!!

Thanks again, you guys are the best!

I thought I would post this separately... I would like a button on my form once clicked to delete the record then exit the form. How can I do that?" Thanks again!

Perfect, thanks guys! Now, if iResponse is vbYes, I need it to close the form...suggestions?

Thanks, and oops you are right on the 0 and -1. Here is what I have: Private Sub CkTMJob_Closed_Click() If CkTMJob_Closed = -1 Then iResponse = MsgBox("Are you sure you want to close this job?", 1 + vbQuestion, "Close Job") If iResponse = vbYes Then Exit Sub If iResponse = vbCancel Then...

Is "strContactEmail" the name of the check box?

"I am trying to use a MsgBox when a button is clicked. The Warning comes up asking "Are you sure you want to Close this Job". If they click yes, then ckTMJobClosed check box is clicked (or 1), if they click no, then the check box is left uncheck (or 0). Once they select the form then closes...