MS Access validation and consistency

[black-ops]

Ok im not sure how i would go about doing this. But there are two fields in a table one is gender with a validation rule of "M" or "F" , how would i go about making sure that if "M" is entered then only "Mr" is allowed into the title field?
Thanks,

 

[~J~]

Either the "Case" statement of a simple "If"

[psuedo]
pSex=cboSex.Text
cboTitle.Items.Clear
if pSex="M" Then
cboTitle.Item.Add("Mr.")
Else
CboTitle.Item.Add("Mrs.")
cboTitle.Item.Add("Miss")
cboTitle.Item.Add("Mz.")
End If