Automatically adding a note when a new client is added.

  • Thread starter Thread starter Cassie
  • Start date Start date
C

Cassie

I have a Notes subform on a customer form. Does anyone
know how to make it so everytime I add a new customer a
notes record is automatically saved for the new customer.

Reason is I have a report I run that won't display a
client's information unless they have a note.

Thanks
 
Use the AfterInsert event of your form to insert a note into the table.
Execute an append query statement.

However, there may be a better way to fix the problem. Presumably the report
is based on a query that has both the Customer table and the Notes table. If
so:
1. Open the query in Design View.

2. Double-click the line joining the 2 tables.
Access offers you 3 options. Choose the one that says:
"All Customers, and any matches in Notes."

3. Save the query.

By default, the query gives you an "inner join", so any customer who has no
note is not included. Changing it to the outer join should solve your issue.
 
Back
Top