to use one value for populating new form

[ritu]

hi
i m new user for the ms access i have table employee
i wan to create a form with a sub form , on the form i wan toc all the
information of themanagers and i want o c athe names in a combobox so that
when i choose the name of the manager it ask me for the manager id and after
filling in id it give me all the informaton of the employees who r working
under that manager.

 

[TonyT]

It would be easier to have a combobox with its rowsource set to tblManager
and then have a listbox showing the employees associated with that manager,
rather than having nested subforms, especially if you are just starting out
with access.

TonyT..