Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Have combox look-up record?
Credit to "petrosky" in the Access General Discussion forum for the answer to this question. However, you will need to use an unbound combo box on your form and do the following: Invoke the query builder for the rowsource of the Unbound combo. Add tblDoctors to the query builder then...- DAGOLF
- Post #2
- Forum: Microsoft: Access Forms
-
Create "record selector" form "combo box" from related table
Peter: I really I appreciate your info which was right on the money. I have one more question (a common but all to often cry from the unknowledgable). Now that I am able to select an Encounter record from the combo box by patient name, I would like to scroll through various Encounter records...- DAGOLF
- Post #3
- Forum: Microsoft: Access Other topics
-
Create "record selector" form "combo box" from related table
I have a one to many relationship between a table (tblPatients) whose primary key is "PatientID" and a second table (tblPatEncounter) which has "EncounterID" as its primary key field. The field "PatientID" is related in a one to many relationship with the second...- DAGOLF
- Thread
- Replies: 4
- Forum: Microsoft: Access Other topics
