list box or combo box

  • Thread starter Thread starter LMB
  • Start date Start date
L

LMB

Hello Everyone,

I have a table with physician names, I also have a table with physician
specialty. On the form, I want the user to select the physician from a list
and then have the specialty automatically filled in. Eventually I will need
to figure out how to let the user add a name to the list as new physicians
will be hired. I think this will be a multiple step process so I need to
know which one to start with and then how to proceed onto the next step then
what to ask at that point to get this working. I don't have the form
created yet, I am working on that. Let me know if there is anything else I
need to report.

PS...I'm not a programmer and still a beginner at this. I have been reading
some books suggested by the groups but they still seem like a foreign
language to me.

Purpose of database is to audit patient charts and compare the number of
treatments actually ordered to the number of treatments actually needed
based on order set criteria.

Here are my tables that have fields related to physician...
------------------------
tblPhysicians

PhysicianID pk
PhysicianLName
PhysicianFName
PhysicianNumber
PhysicianSpecialtyID fk
-------------------------
tblPhysicianSpecialty

PhysicianSpecialtyID pk
PhysicianSpecialty
-------------------------
tblTreatments

TreatmentsID pk
PatientID fk
AuditDate
TreatmentsOrdered
AuditTreatments
PhysicianID fk
AuditorID fk
 
Add the Physician Specialty table to the rowsource of the combobox so it
looks like this:

SELECT PhysicianID, PhysicianFName & " " & PhysicianLName,
PhysicianSpecialty FROM tblPhysicianSpecialty INNER JOIN tblPhysicians ON
tblPhysicianSpecialty.PhysicianSpecialtyID=tblPhysicians.PhysicianSpecialtyI
D;

Then set a textbox controlsource = to the 3rd column (zero based):

=[Forms]![YourFormName]![cboPhysicians].Column(2)
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access
 
Back
Top