Subform only showing one record (filter)

  • Thread starter Thread starter Jay
  • Start date Start date
J

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
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

changing mainform record from subform 3
Perform Action Only on Filtered Records 1
Yet another filter Subform by Combo Box 1
Filter main form to records with no related records in subform,maintain updateable recordset 4
Double Click Open Form Filtered 7
Pass Subform filter to subform in report 0
Refresh data in sub forms when one sub form is edited 4
Getting a subform to Show All records 13

Back
Top