From: dosima on
hi

i have a form which shows customer details, and this has a subform where you
can enter the date and notes about the customer. the subform is in a
datasheet view. so everytime you want to add some notes about the customer,
you enter the date and write the notes.

there are many customers on the database, and we make quite a few notes for
each customer.

Now when i go into the customer and put in a note, then come out and go back
into it, the data has moved up a few columns and goes into the wrong place,
rather than stay in the same place where it was entered.

also when notes are added in each record, it's not always dated as we enter
the notes up to a certain line, then carry on in the next record. this is why
he column is not ordered by date, it should be the recent information entered
at the bottom

i would be grateful if someone could help me and tell what i do to resolve
this.

dosima

From: Jeanette Cunningham on
You could put a default value for the date in the date control's default
value on the date controls property dialog.
If you put
= Now()
for the default value, the date and time will be stored with each record.

Then you can sort the subform's record source by date ascending.


Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia

"dosima" <dosima(a)discussions.microsoft.com> wrote in message
news:30D396B6-848C-4BF9-9D4C-E3475C0073EC(a)microsoft.com...
> hi
>
> i have a form which shows customer details, and this has a subform where
> you
> can enter the date and notes about the customer. the subform is in a
> datasheet view. so everytime you want to add some notes about the
> customer,
> you enter the date and write the notes.
>
> there are many customers on the database, and we make quite a few notes
> for
> each customer.
>
> Now when i go into the customer and put in a note, then come out and go
> back
> into it, the data has moved up a few columns and goes into the wrong
> place,
> rather than stay in the same place where it was entered.
>
> also when notes are added in each record, it's not always dated as we
> enter
> the notes up to a certain line, then carry on in the next record. this is
> why
> he column is not ordered by date, it should be the recent information
> entered
> at the bottom
>
> i would be grateful if someone could help me and tell what i do to resolve
> this.
>
> dosima
>