I'm creating a navigation form in access and I'm trying to add a combo box in the header of the form to search for records in a subform which is in a database sheet format. For example, I should be able to type or select the name of an employee and take me to that record in the database sheet form which is a subform in the navigation form.
Also, In the subform in the navigation form I would like to click on the name of the employee and be able to open the form where all the detail information of this employee is.
I know that to do these two things I have to write a code or create macros but I tried everything and I can't figure it out!! Can you give me a hand?
I would appreciate!!!