Datasheet view in a columnar form
Posted on 2006-11-09
I have a table consisting of 5 fields. I used the Form Wizard to create a new form containing the 5 fields. I used the COLUMNAR layout for the form, which placed the fields and labels on the columnar form, one above the other. This is all fine and great. However, the problem with columnar layout is that there's no way to view more than one record at a time for the sake of jumping to another place in the table. In other words, let's say I have 1000 records in the table. Well, when I'm viewing my columnar form, I can only see one record (e.g., indexed field: Lastname = record #1: "Anderson"). But let's say I want to jump to the first record where the last name begins with the letter J. Currently I have to hit the navigation button hundreds of times in order to get to the first record with the letter J. This is a ridiculous method to navigate through the table, obviously. I was hoping there was a way to have quick access to the entire table simply for the purpose of being able to jump to another record, and then return back to the columnar form once the current record position has been placed in the first record that begins with the letter J. There's simply got to be a better way to navigate a columnar form other than clicking "Next>" a hundred times.