Thread: jumping data
View Single Post
  #1  
Old April 16th, 2010, 06:28 PM posted to microsoft.public.access.forms
dosima
external usenet poster
 
Posts: 20
Default jumping data

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