Dear experts -
We have a workhorse form (it shows a given project) that contains a separate tab with a subform listing all the expense items for that project. The subform/expense table has many fields - we display quite a few of these across the row.
NOW - until today, we have allowed additions on this form - however, this is a pain, since you need to scroll to the bottom of the list to add a record.
So, I was thinking of alternatives, such as:
1) Have a separate subform only for adding records. Would be nice to have an accelerator key that puts the user here at the touch of a button.
2) Have a 'new expense' button, that invokes a popup.
In either case, after entering the record, we can refresh the main expense list and go to the record just entered.
What are your thoughts of the best way to do this?