Specific Text Box Needed on a form

[Dlynn]

I need to add a field on a form that gives you notes, but I also need to see the date the note was added, does anyone know a way to do this?

Thanks Alot for your help

 

[mickeyg]

Will need a little more information to help you out.
Is the create date stored in a field?
Do you only want to view the create date?

Mickey

 

[Dlynn]

Mickeyg,

I am setting up a help desk type database. I need to do the following:

Have a field called notes that I could put several notes in it & a date field attached to each note.

Ie.

Here is what the database looks like

Customer Name
Account Number
Then I will need the note field to look something like this

Notes 12/31/01 Customer Had read right error
Notes 12/20/01 Customer couldn't login.

I hope this helps

 

[mickeyg]

If this is read-only (or no changes need to be saved on this field), create an unbound text box. In its control source property set it to =[MyNoteDate]& " " &[MyNote].

Otherwise, I would suggest a main form with customer name and account number which is related one-to-many by account number to your notes table. Then in your subform add your two fields.

Thus your form would look like the following:
Account No: 454
Customer: Joe's Garage

Notes Subform:
Date Note
12/31/01 Customer Had read right error
12/20/01 Customer couldn't login.

Good luck,
Mickey