Hi all
I am not very good at Access but with basic idea.
I have an entry form. A drop down list with subject names.
I also have two fields for Schools.
I want the form to show only 1 field for school (by default).
But I want the second field to show base on the selection done in subject name.
Example, if subject is nursing, then show both school fields, if subject is something else, just show 1 field.
Any help please?