Option to specify an item that is not listed

Will04

Registered User.
Local time
Today, 18:05
Joined
May 29, 2006
Messages
62
Hi everyone,

I'm building a database that will allow me to enter medical information about patients. On the present form (paper) one of the question asks about the medical history of the patient with 7 available options( Diabetes, Cardiac, HIV etc). The 7th option is 'OTHER' and the patient is supposed to specify what Other refers to.

How can I translate this to an Access form?

I am thinking of a list of the 7 options, but when option 7 is selected; the user should be prompted to enter a specific disease.

QUESTION?
How can this be achieved, and how should the table be designed to accept this entry?


All help appreciated

Thanks

Will
 

Users who are viewing this thread

Back
Top Bottom