I have two tables, Clients and Projects. I have a form based on Clients, with a sub form based on Projects. When I go to a record in the clients form, the projects subform shows the projects for that client. So far so good.
But, I have some clients that don't have any projects associated with them. When I go to those client records in the form, Access automatically creates a new project. Even if I don't click anywhere in the projects sub form, a new record is created and saved.
What I would like is to be able to view and edit these client records with out adding a project record, and for a new project to be added only if I take some positive action (e.g., enter data in the project form, click a command button, etc.) Any suggestions?
Thanks!
But, I have some clients that don't have any projects associated with them. When I go to those client records in the form, Access automatically creates a new project. Even if I don't click anywhere in the projects sub form, a new record is created and saved.
What I would like is to be able to view and edit these client records with out adding a project record, and for a new project to be added only if I take some positive action (e.g., enter data in the project form, click a command button, etc.) Any suggestions?
Thanks!
