MS Access validation and consistency

Associate
Joined
4 Mar 2007
Posts
315
Location
United Kingdom
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,
 
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
 
Back
Top Bottom