Call History Maintenance

  • Thread starter Thread starter JOE POLLOCK
  • Start date Start date
J

JOE POLLOCK

I have a form which I use to maintain call records from outgoing calls. I
would like to have a section on that form that will show the records of all
previous calls from that particular contact. Please advise on any macros or
vb code. Thank you.
 
How are you storing the previous calls? Post table and field names with
datatype. Post sample data.
 
Sorry. Then I guess I am just overwriting the old records. I would like to
know how to maintain a history. The form that I have is based on a query of
the main table.
 
I have a form which I use to maintain call records from outgoing calls. I
would like to have a section on that form that will show the records of all
previous calls from that particular contact. Please advise on any macros or
vb code. Thank you.
Click to expand...

Data isn't stored in forms. It's stored in Tables.

As Karl asks... what Tables do you have in the database? How are they related?
What's the Form's Recordsource property?

You should have (at least) two tables: a table of Contacts related one to many
to a table of Calls for that contact. If you don't... you need to redesign.
 
Ok. I have two tables, one for calls and the other for contacts. I created a
query for them. What would my next step be to reach a point where I can place
a form on the main contact form to maintain the history of the calls. Pardon
my ignorance.
 
Post the table and field names with the datatype. Post sample data.

How do you flag call complete?

Does your form use a query? If so, then post the SQL by opening in design
view, click on VIEW - SQL View, highlight all, copy, and paste in a post.

If no query then open the form in design view, right click the form, scroll
down to select Properties. Copy the Record Source and paste in a post.
 
Assuming you have a common field (example, UserID but probably not UserName
because there's so much duplication in real word names) in the Contacts and
Calls records, and the Calls include date/time or some other field to use to
order them: create a continuous form for displaying call records, then
create a Subform Control on your main Contact form, into which you embed the
continuous form, and set the LinkMasterFields and LinkChildFields properties
of the Subform Control to refer to the common field in the main Contact
record and in the Call records displayed in the Subform Control.

Larry Linson
Microsoft Office Access MVP
 
Back
Top