Prakashpdl
New member
- Local time
- Today, 08:24
- Joined
- Apr 25, 2020
- Messages
- 27
Hello,
I am new to access and can design simple forms and tables.
I am designing a form for patient's record. I have one table to record the data from which I have created the form with the same field names. I have two situations.
1. Combo 1 (CboExamination) --Options = Normal, Abnormal and not done
Next field (Field 1) is "Examination finding"
If I select "Normal" from CboExamination, susequent field (Field 1) should have default value as "Normal"
If I select "Not done" from CboExamination, susequent field (Field 1) should have default value as "Not done"
If I select "Abnormal" from CboExamination, susequent field (Field 1) should be blank so that I can enter examination findings.
How can I do that?
2.
Combo 2 (CboInvestigation) --Options = Done, Not done
Next field (Field 2) is "Blood report"
Next field (Field 3) is "Urine report"
Next field (Field 4) is "Stool report"
If a select "Not done" from combo 2, subsequent 3 fields should disappear
If I select "Done" from combo 2, subsequent 3 fields should appear (preferably with default value "Normal" where I will enter the abnormal report if reports are abnormal and leave the default values if reports are normal.
How can I do that?
Please help
I am new to access and can design simple forms and tables.
I am designing a form for patient's record. I have one table to record the data from which I have created the form with the same field names. I have two situations.
1. Combo 1 (CboExamination) --Options = Normal, Abnormal and not done
Next field (Field 1) is "Examination finding"
If I select "Normal" from CboExamination, susequent field (Field 1) should have default value as "Normal"
If I select "Not done" from CboExamination, susequent field (Field 1) should have default value as "Not done"
If I select "Abnormal" from CboExamination, susequent field (Field 1) should be blank so that I can enter examination findings.
How can I do that?
2.
Combo 2 (CboInvestigation) --Options = Done, Not done
Next field (Field 2) is "Blood report"
Next field (Field 3) is "Urine report"
Next field (Field 4) is "Stool report"
If a select "Not done" from combo 2, subsequent 3 fields should disappear
If I select "Done" from combo 2, subsequent 3 fields should appear (preferably with default value "Normal" where I will enter the abnormal report if reports are abnormal and leave the default values if reports are normal.
How can I do that?
Please help