goto new record automatically in subform!!

[rich_bell20]

hello everyone

I have a form, which contains a subform - in datasheet view. there are 100 rtecords in the subform datasheet. i have used a macro so that when the subform is opened, it goes to a new rrecord.. but when i clcik on the next record of the main form, to enter data on the subform datasheet for that one, it takes me back to the top!! meaing i have to scroll down to the last record for every other record in the main form!! is there any way that i can keep it going to a new record int he subform, everytime i clcik on the next record in the main form??

Thanks!!

Richard Bell

 

[llkhoutx]

Sounds like the table (recordsource) asssociated with the subform is index incorrectly.

 

[rich_bell20]

sorry....

sorry but i dont think i have them wrong, or i don't understand what u are trying to say i need it to go to the last recrd everytime for each customer to save me having to scroll down them all to find the latest date... ive included the database here for download if you would be so kind to look at it. thanks