Automatically fill in form from combo box selection

[SeanK6876]

I have a patient log form that I want to fill in by Social Security Number.
It looks like this:

SSN Last Name First Name MI
111-11-1111 Smith John J

I want to have a patients table that the primary key will be SSN. I want to
be able to start typing the SSN in the form and if the patient has a record
it will fill in Last Name, First Name, and MI automatically. However, if that
patient does not have a record in the table I want to fill in the fields
myself and have it saved to the table.

Is this possible?

 

[Larry Daugherty]

Yes. Use a Combobox and use the NotInList event. There is Help on
it.

HTH

 

[schasteen]

It is possible. You will have to put some code in the form to insert the
data into the tables. You may check out this site to get you started
http://www.mvps.org/access/forms/frm0015.htm