|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
December 15th, 2005, 03:56 PM
posted to microsoft.public.access.forms
|
|||
|
|||
Autocreate records from continuous form
Hi,
I have a continuous form based on a query that gives a list of contacts, which I then use for a mail merge. Now I wish to know whether it is possible for me to add a field in the form header where the user can select a date and a type which will then create new records in a new table that would be called communication ? Here's how my DB kinda looks... Contacts --------------- ContactID ContactName .... Project ---------- ProjectID ProjectName .... Calls ----------- CallID ContactID (relation) ProjectID (relation) .... Goal would be to have a new table : Communication ---------------------- CommunicationID ContactID ProjectID Date Type (combo) So that via the continuous form I create records automatically so that I can link the sent fax info. Is that possible and if yes... How ? Thanks, Ben -- Novice 
|
|
#2
December 15th, 2005, 04:10 PM
posted to microsoft.public.access.forms
|
|||
|
|||
|
Autocreate records from continuous form
Perhaps with checkboxes to select those that you want to create a record for...
-- Novice "Ben" wrote: Hi, I have a continuous form based on a query that gives a list of contacts, which I then use for a mail merge. Now I wish to know whether it is possible for me to add a field in the form header where the user can select a date and a type which will then create new records in a new table that would be called communication ? Here's how my DB kinda looks... Contacts --------------- ContactID ContactName ... Project ---------- ProjectID ProjectName ... Calls ----------- CallID ContactID (relation) ProjectID (relation) ... Goal would be to have a new table : Communication ---------------------- CommunicationID ContactID ProjectID Date Type (combo) So that via the continuous form I create records automatically so that I can link the sent fax info. Is that possible and if yes... How ? Thanks, Ben -- Novice
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Problem selecting records in continuous form | Scott A | Using Forms | 3 | November 17th, 2005 12:23 PM |
| Edit properties of linked subforms problem (repost) | Allen Browne | Using Forms | 3 | November 12th, 2004 08:16 PM |
| Continuous Subform / Form - Orphan records | Rich J | Using Forms | 6 | October 15th, 2004 08:59 PM |
| Question: adding records to a continuous form using controls in the footer | Matt | Using Forms | 2 | June 15th, 2004 12:22 PM |
Linear Mode
