jumping data
in [Form]
|
Prev: data entry in subform before mainform causes huge hassle, HELP!
Next: Access 2007-Duplicate Record Field Capability
From: dosima on 16 Apr 2010 13:28 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 16 Apr 2010 17:09
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 > |