Hi all. I'm new to Access, and I'm trying to make one input form that I can use to input patient data and specify which Care Coordinator's table it goes to with a selection on the form. For instance, if I were inputting John Doe's info, and wanted it to go to CC#1of10, I could put in:
Doe
John
Pt Identification #
DOB
Phone #
Diagnosis
Care Level
Category of Care
Address
City
State
Zip
CC1 (selectable list 1-10)
and that would go to table "CC1"
Is that possible?
Also, in trying to build a combo box with a selectable list (like State, or CC) I'm having trouble getting it to allow me to edit the list properties. I have the Control Source "State" and the Row Source <"AZ";"CO";"ID";"NV";"UT";"WY"> so I could select one of the 6 in our region. Is there something I'm missing there?
Thanks in advance,
Criss
Bookmarks