I have a form for entering Competitor Detail on it is a control that displays the competitor's age, based on their birthday as entered in the Contacts table. I've created a button that displays only when the age is null. That button opens the Contact Details form. I have the code set to open the Contact Details form. I need it to open the form for that specific contact and if possible put the focus on the Birth Date control. So far this is what I have
Private Sub EditBirthday_Click()
DoCmd.OpenForm "Contact Details"
End Sub
The CompetitorDetails form has a control called ID which is the ID of the competitor in the Contacts table and on the Contact Details form. Birth Date is the name of the control on the Contact Details form.
What do I need to add to my code to get the desired result?