I've got a bit of a UI issue with a subform & a datasheet in one of my forms. I am making an Inventory database, a form contains the product details and also a subform containing the transaction details (units in, out, adjustments). I.e. it's basically in the same mould as many of the Access2k3 templates offered by MS (http://office.microsoft.com/en-us/templates/CT101426031033.aspx).
What I want to happen is that when the user loads up the form, if the datasheet has too many rows to display in the subform (i.e. its height is more than the subform's height) that the user doesn't have to scroll the subform just to add a new row.
I can see two possible solutions, but can't figure out how to implement them:
1) Display the datasheet contents in reverse so the "New Record" row is at the top of the datasheet. But reverse-chronological ordering of events with the newest events at the top of a datasheet isn't as intuitive as the normal order. ( this isn't the same as "ORDER BY id DESC, the "New Record" row is still at the bottom).
2) On loading the subform, somehow make the "New Record" row the active row - I can't figure out how to do this!
Has someone tackled this problem before and knows how I could fix it? Maybe I'm looking at how to get this done the wrong way... many thanks in advance.
What I want to happen is that when the user loads up the form, if the datasheet has too many rows to display in the subform (i.e. its height is more than the subform's height) that the user doesn't have to scroll the subform just to add a new row.
I can see two possible solutions, but can't figure out how to implement them:
1) Display the datasheet contents in reverse so the "New Record" row is at the top of the datasheet. But reverse-chronological ordering of events with the newest events at the top of a datasheet isn't as intuitive as the normal order. ( this isn't the same as "ORDER BY id DESC, the "New Record" row is still at the bottom).
2) On loading the subform, somehow make the "New Record" row the active row - I can't figure out how to do this!
Has someone tackled this problem before and knows how I could fix it? Maybe I'm looking at how to get this done the wrong way... many thanks in advance.
