New record - UI considerations

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?

Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Jeffrey CoachmanMIS LiasonCommented:
<since you need to scroll to the bottom of the list to add a record.>
Just to be clear, when you click the new record button, it "brings" you to the bottom of the form, ...there is no need for you to scroll to the bottom manually...
Does simply clicking the new record button fix this issue?

Also you could make this a single form view form, ...then clicking the new record button simply blanks the form, and you are ready to type the new record.

If neither of these work for you, then yes, you can create a separate popup form, but this would be overkill in IMHO...
(Create the popup form and set all the needed "popup" properties and create the code to refresh the main form...)

terpsichoreAuthor Commented:
we don't currently have a 'new record' button - the user has to manually scroll to the bottom each time...
Jeffrey CoachmanMIS LiasonCommented:
...Is there a reason why you can't add one in...?
(if this solves the problem)

Again, you could do what you are asking but it overkill IMHO

Create a form based on the table.
Set the data entry property of this form to "Yes".
On the main form put code to open this form for a new record:
    DoCmd.OpenForm "YourPopUpForm", , , , acFormAdd, acDialog
On the close event of the Pop-Up form put code like this to refresh the main form

This should work for you, but doing this introduces a lot of other issues, (if the main form is not open when this popup is opened, ...etc)
...just FYI...


Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
The Ultimate Tool Kit for Technolgy Solution Provi

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy for valuable how-to assets including sample agreements, checklists, flowcharts, and more!

terpsichoreAuthor Commented:
thanks - this is very helpful
Jeffrey CoachmanMIS LiasonCommented:
<this is very helpful >
Which path did you opt for?
Adding a new record button or creating a pop-up form.

(Just so other members searching here can know what resolved the issue)

Glad I could help...

terpsichoreAuthor Commented:
I am leaning right now to a popup - because in the process I can also add more info in the UI to guide the user when they are entering data - the continuous form is very dry and just a string of fields (of necessity - it's a lot of fields).

but it's a work in process!
Jeffrey CoachmanMIS LiasonCommented:

It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.