multiple rows from one form?

[Guest]

I'd like to use a single form for data entry that will let me enter amounts
into any or many of up to ten text boxes, one box for each of ten accounts.
Then for each text box entered, I'd like to build a single row with user
info, the account number and the amount entered.

 

[Arvin Meyer]

You'll need a spreadsheet for that, or you can denormalize a database so
that it will require adding a field every time you want to add an account.
The problem with Access forms though is that even though a table can hold up
to 255 fields (accounts?) a form can only be a maximum of 22 inches wide, so
you'll never be able to display more than a few dozen columns.

Look at the Northwind sample database that came with Access for a
rudimentary idea of how to design a database structure. Better still buy one
of John Viescas's or Michael Hernandez's books on database design.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access