Hi all,
On my form i have a txt field called Attn and a check box that if not null when ticked true, will add that to my temp address...
I added this msgbox to eliminate an error when ticking the PopulateAttn checkbox if nothing is in the Attn field.
I want to add to this if I tick the checkbox to = false (Untick it) and there is something in Attn, it will clear the the Attn field.Code:Private Sub PopulateAttn_Click() If IsNull(Attn) Then MsgBox "Attn is blank, you must assign to someone's attention" Me.PopulateAttn = False End If UpdateTempAddress End Sub
So basically if my name is in Attn field and I tick the check box it will put in what is in the Attn box into my temp address field.
If I untick that box, i want it to remove my name.....
Any assistance would be wonderful...
Thanks
Dave