Button command

[Karyn]

One of our nurses would like to click a button on the form and another screen would open up to type notes and comments. They are currently hand writing and tracking their notes in a notebook. Can this be done? Thanks for any help in advance.

 

[stimpy]

Im no expert but here is how I did it:
The notes can be entered into a field in the table that the form is linked to.
Add a new field in the table for the notes to go in and make its data type memo if the notes will be longer than 255 chars.
Then make a form that contains a text box bound to this field.
Then put a button on the first form called Notes or something, and make the button open the second form

Let me know if this explanation needs for info

 

[Karyn]

I have a few questions:
1. I have a main form and one subform that are linked. Do I add the notes and comments field to the main form or do I set up a separate table called notes and comments and a separate form?
2. Once I add a button and I click on that button to open up the notes and comments form, do I have to have a linking field to the main form?
3. Every time I am in the main form and I click on the notes and comments button, will it give me a blank screen to enter the information?

I am having a problem but I don't know what it is!!! If you can help me, I would greatly appreciate it.

 

[Pat Hartman]

You should have a separate table to hold the notes. It should contain the following columns:
NoteID (autonum, primary key)
NoteDate (default to Now() to get the current date/time)
PatientID (each patient should have a unique id assigned already. this will be a foreign key to the table where that ID is maintained)
NurseID (each nurse should have a unique id assigned already. this will be a foreign key to the table where that ID is maintained.)
Notes (memo field so that notes can be lengthy)

You probably want to use a continuous form for the notes so that the previous entries can be seen when the new entry is being made. You should also offer sort and filter options so that nurses can see only their own notes or everyone's notes and choose the order in which to view them.

I presume that patientID will be the linking field. If that is not the case, then alter the notes table structure to contain whatever field you need to link the notes to the main form.
I would suggest that you do not allow notes to be updated, only added. That way you make sure they don't make a mistake and overwrite some not they made previously.

 

[Richie]

Presumably your main form has the patients name and the subform has details relating to the patient, why not add a tabbed page to the subform containing notes.