Subform only showing one record (filter)

[Jay]

Hello,
I am having a problem. I have a main form based on a table that
tracks personnel information. I have created a subform on my form to
track the different projects an employee has worked on. I needed to
use a command button, so I used the command button wizard to open the
subform, and chose to match the employee id to the project id. When I
click on the button the form opens, allows me to enter the data, but
when I close it and reopen, the records don't show up, and on the
bottom it says "record 1 of 1 (filtered)" Can anyone tell me how to
fix this. Almost forgot, the project data is stored in a different
table.
Jason

 

[jleckrone]

I don't think you want to match the employee ID to the ProjectID, but
rather match the Employee ID to Employee ID for each table, the
employee table and the project table

 

[Jay]

I am going to try that out, I will get back to you tomorrow. Thanks
for the help.
Jason