Good afternoon,
I have an access database that tracks case numbers and details. Case numbers are written as 2003-001, 2003-002, etc. On the form where you enter information about each case, I have a command button that opens up a second form on which you can enter detail information for the case. For instance, Report opened on 1/1/03, Sent to ADP on 3/5/03, Final draft prepared on 5/5/03, etc. The child form is linked to the parent by case number. Each detail is listed as a separate file and flows into a case details table. My table has two columns, one for the case number and one for the details. Case number is repeated for each detail, which allows it to be linked to each individual case and my sort is by case number so all details for each case are together.
Detail information is input sequentially into the subform by date of occurance. However, when I input a new record, instead of putting it in the table at the end of each case number, for some reason Access throws it in the middle. Then, when I bring up my form (and subsequent report), the detail are invariably out of order... Any suggestions on how I can get the new detail record to come in at the bottom or why the form is not reading the records in the order they appear in the table?
Thanks
MySki
I have an access database that tracks case numbers and details. Case numbers are written as 2003-001, 2003-002, etc. On the form where you enter information about each case, I have a command button that opens up a second form on which you can enter detail information for the case. For instance, Report opened on 1/1/03, Sent to ADP on 3/5/03, Final draft prepared on 5/5/03, etc. The child form is linked to the parent by case number. Each detail is listed as a separate file and flows into a case details table. My table has two columns, one for the case number and one for the details. Case number is repeated for each detail, which allows it to be linked to each individual case and my sort is by case number so all details for each case are together.
Detail information is input sequentially into the subform by date of occurance. However, when I input a new record, instead of putting it in the table at the end of each case number, for some reason Access throws it in the middle. Then, when I bring up my form (and subsequent report), the detail are invariably out of order... Any suggestions on how I can get the new detail record to come in at the bottom or why the form is not reading the records in the order they appear in the table?
Thanks
MySki