If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
jumping data
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" wrote in message ... 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 |
Thread Tools | |
Display Modes | |
|
|