multiple notes

[JonatABS]

Im creating a small data base to keep track of some calls that come into the office based on an employee number.

I got a multiple tab form
the first tabe is all the employees information and the second tab is for logging notes per call.

Is there a way to keep the same employee up but log a new note whenever a button *new note* is pressed.

I already have a table setup with a field called techcallnotes. What do I need to do to accomplish this?

Thanks much guys, I appreciate it.

 

[shuff]

I'd put a subform on that second tab that displays all call notes for the employee, linked by employee ID, or SSN, or some other exclusive field. In creating the subform, I would take care to show the fields that one might want to filter on, because when the list of call records gets lengthy, one might want to filter the list, say, by most recent 10 days, or by call length > X mins, or whatever. I do something similar to this in a Project management database, where projects with "Joe" as the owner display in a subform when Joe's employee record is selected. Then on my subform, I can look at all Joe's projects, just the completed ones (CompleteDate), just the overdue ones (DueDate vs. Now()), etc.

Hope this helps.

SLH

 

[JonatABS]

subform reply

Hello,

I got your reply about how to log multiple notes, and was hoping you could expand on that a little for me.'

The only really exclusive field I have is on the first tab of a multitab form. That field is the employees ID number.

The problem im having is linking that field to the subform. Upon going though the subform it did ask for it and I did select Employee ID. However when imputting a note it excepts the first one then I want to add a second note and I get an error message that reads " You cant assign a value to this object."

It gives three reasons why the error may be happening.

1. The object maybe a control on a read-only form.
2. The object may be on a form that is open in design view.
3. The value may be too large for this field.

I have no idea what is going on.

Also the autonumber field on this form jump to about 1000+ number when im only on like 5 or so.

I have a downsized version of this program if you would like to see it. It would be appreciated as im dumb LOL. I was pushed into this and I need to get it done. This isnt my number one hobby I can tell you that much

 

[shuff]

Sure - email me the smaller file and I'll take a look.

SLH