Entering multiple records with one form

  • Thread starter Thread starter Steve Moody
  • Start date Start date
S

Steve Moody

Hello,

I am trying to setup a single form that will enter several records into a
table at once. Does anyone have a hint as to how this might be possible?

Here's some more specific information as to what I am doing. I have a table
that stores just two columns of data. One column is a description and the
other column is the value. To make data entry easy for the secretary who
will use this, I want to make a form. There are only four possible types of
data that a value can be associated with, but each customer doesn't
necessarily have a value for all four types. So I thought a subform with a
pulldown menu would work great. It did. But the people doing the data entry
think it is inefficient to have to interrupt data entry my using the mouse
to grab a value from the pulldown box. I would rather set it up so that
there are 4 text boxes in which they can enter their data. If there is no
value, they can enter a zero. BUT, if there is a zero, I don't want that
value to show up at all on the report. There is a lot more to this problem,
trust me, I've tried queries, macros, just about anything and there is
always something wrong. Simply, if I could have a form that would enter 2-4
records into a table with one mouse click, I could probably fix it from
there. Any ideas? Thanks!!

Steve Moody
 
But the people doing the data entry
think it is inefficient to have to interrupt data entry my using the mouse
to grab a value from the pulldown box.
Click to expand...

Well... they DON'T have to interrupt data entry. Combos work *better*
without the mouse!

Tab into the combo with the <tab> key. Type the first letter of the
value to drop down. If this is enough to uniquely pick the value (and
you can probably set up your table so it can), it will jump to that
value. Press tab again and you're on to the next field!

Even if it takes two or three characters to find the value, it's still
faster than using the dropdown.
 
Steve,

To be honest, I haven't quite grasped your meaning with some of this.
But as regards your combobox on the form, do the data enterers realise
that they can type the first letter of the item to select it in the
combobox, so interrupting to use the mouse is not necessary?

- Steve Schapel, Microsoft Access MVP
 
Back
Top