Scroll

[=TB=]

Hi all

I have a subform within a form, on update of the first field (location) a subdata sheet automatically expands to show product and qty stored within the location entered.... All this works fine, however after entering about 4 records, the subdata sheet becomes hidden below the window of the subform which means the user has to scroll the subform each time manually, losing focus on the subform which in turn is time consuming when a lot of data needs to be entered. Is there a way off getting the subform to automaticaly scroll after each line of data entry?

Any help on this would be appreciated

 

[bjackson]

why not have the subform data sorted descending that
way the top row is always the last record entered

 

[=TB=]

I don't understand how this will work sorry? Perhaps I have not explained the problem clearly enough. The subform is in datasheet view, has 3 columns, first column the user enters a location, on update property of this field is set so a further subdatsheet expands (subform within a subform). This second subdata form then closes again on update of the 3 rd field (Qty), the user then tabs to start entering the next record and the cycle repeats, however once the user gets so far into entering records, the second subdata form becomes obscured when it expands behind the main form, this is mainly due to the fact that I have all of the second subdata sheet expanding for all records entered within the subform

Private Sub Crate_AfterUpdate()
SubdatasheetExpanded = True
End Sub

Is there a way to only expand the second subdatasheet for the last record entered? I think this might cure it.

Screen shots zipped, sorry they are in word I don't have any other software on the machine I am using today.