Ok, so I have been teaching myself SQL and advanced Access, and I almost have what I need figured out, but I am missing one key component!
(and a few more, but you get the idea)
In the Form:
I have a combo box in my header with the ID#, and a Requery setup for AfterUpdate and On Exit. Under Detail, I have text boxes bound to Name, DOB and Location. Both the Combo Box and the Text Boxes pull from the same Table. I have a sub-report with appointments that is associated with the text boxes, and that is set up correctly (yeah!). However, when I select an item in the Combo Box, instead of the text boxes refreshing to the row specified in the combo box, it refreshes to the first row of the table. I just need to connect the two and I am done! Help???