Mohamed, you should probably open the sample Northwind database to study how subforms work. Perhaps this will help with your analysis...
Lets suppose you give your combo box the name "cboEmpNumbers". The settings for the combo box should be:
Row Source Type: Table/Query
Row Source: The query you specified (or something better, see below)
Bound column: 1
Limit to List: Yes
Column count: 1 (but I have another idea with something better)
Create a subform with a query that includes EmpNumber and whatever fields you want from your PayMstr and FamMstr tables. The subform on the main form will have these properties:
Link Child Field: EmpNumber
Link Master Field: cboEmpNumbers (your combo box field)
I would recommend that that your query for the combo box Row Source be:
Select EmpNumber, EmpName from EmpMstr Order by EmpName
Then change the properties for the combo box as follows:
Column Count: 2
Column widths: 0";2"
List Width: 2.25"
This will display the name of the employee instead of the employee's number.
Hopefully that will get you started.
Randall J Weers
Membership Vice President
Pacific NorthWest Access Developers Group