hi budies
i want to develop a database to my own office work. so i began with access.
in the search form i want to search on different criteria and in each case the fields that i want to be displayed are different . like that when i search with last name all the peoples that have the same last name be displayed in a continuous subform but without the last name field and if i search with job title this field be hidden.
and another question is how i make link with displayed records to a detail forms with that record.
i want to develop a database to my own office work. so i began with access.
in the search form i want to search on different criteria and in each case the fields that i want to be displayed are different . like that when i search with last name all the peoples that have the same last name be displayed in a continuous subform but without the last name field and if i search with job title this field be hidden.