Jan,
You should be using an "EMAIL subform" on your main contacts form. If you don't enter anything in the subform, a record won't be added.
Duane Hookom, MVP
MS Access
To: MS_Access_Professionals@yahoogroups.com
From: MS_Access_Professionals@yahoogroups.com
Date: Thu, 16 Apr 2015 08:50:47 -0700
Subject: [MS_AccessPros] Input form question
I have a table with CONTACTS and a separate table for EMAILS. I use a separate table because many people have more than one email. However, occasionally, I will not have the email address when I am entering contact data.
I created an input form to enter the CONTACT fields and the EMAIL fields. However, it appears if I leave the EMAIL fields blank, I get a null record assigned to the CONTACT_ID in the EMAILS table.
Is there a way of not creating an entry to the EMAIL table if I don't fill in those fields?
Thanks
You should be using an "EMAIL subform" on your main contacts form. If you don't enter anything in the subform, a record won't be added.
Duane Hookom, MVP
MS Access
To: MS_Access_Professionals@yahoogroups.com
From: MS_Access_Professionals@yahoogroups.com
Date: Thu, 16 Apr 2015 08:50:47 -0700
Subject: [MS_AccessPros] Input form question
I have a table with CONTACTS and a separate table for EMAILS. I use a separate table because many people have more than one email. However, occasionally, I will not have the email address when I am entering contact data.
I created an input form to enter the CONTACT fields and the EMAIL fields. However, it appears if I leave the EMAIL fields blank, I get a null record assigned to the CONTACT_ID in the EMAILS table.
Is there a way of not creating an entry to the EMAIL table if I don't fill in those fields?
Thanks
__._,_.___
Posted by: Duane Hookom <duanehookom@hotmail.com>
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (2) |
.
__,_._,___
Tidak ada komentar:
Posting Komentar