Hmm, not really clear how you want to search.
Searching just employees will be simple when defining a search combobox using the wizard (just use the "last" option on the first wizard form).
When you want to see the groups the employee belongs to, then just use the subform wizard on the employee form to add a groups subform and accept the proposed linking field. Access will thus sync the groups for you.
Getting the idea ?
Nic;o)
hi,
i tried working with the code u gave i modified it ...but not clear whats going on....As i dont have that good coding knowledge and iam new in this field .....
My tables have colums like
Employer --- EmployerNum,EmployerName,EmployerAddress,EmployerC ity,EmployerState,EmployerZipCode....
Members----
MemberNum,MemberName,MemberStartDate,MemberEndDate
So i designed seperate forms for them...
But i want to view all these details on one single form with a seperate search button ..
Say the search button on EmployerNum field then i should be able to see all the results from both tables.....
Can u please help....
Thank you in Advance.....