form/subform filter

[sandygo]

I have a form with a subform. The main form is by project and for every project their can be multiple subform entries. Upon opening the database, I have set up a macro that opens the form and filters by person so that the users can see just their records for editing and can add new records. The problem. When the person enters their name and their first record displays, the first entry they see in the subform section is not an entry related to that project. Instead it is always the first entry in the subform table. In the tables, the data is correct, it is just what comes up when they see their first record. It should display the first subform entry for that record.

Also, what is the easiest way to set up a form to open to a new record as opposed to the first record?

Thanks for any help you can provide.