I am at a loss to do something I presumed would be very simple.
I have been asked to create a database for data input purposes.

The users want it to look like excel, therefore I was going to use datasheet view .
The form will contain lots of text boxes ready for user input, they are not bound to anything.
Once users have input details certain validation is done.
My problem is I can only get one lot of my text boxes to show where as the user may want to add 3,5 ,100 records at a a time. So I want the form to have lots and lots of lines of text boxes on it all avalable for update. Once user has finished I append all filled out details to a table, does this make sense...
Thanks in advance for any help you can offer

Create a temp database sort of a holder for the data to be append all in the final table ...

and base your forms record source from the temp table ...
which after delete all records in the temp table, to clear up the data inputed ...

Thanks, this is what I was hoping to do BUT some of the input boxes are lists of data they can choose an option from. I can base the form on an empty table and then validate that user has put correct account numbers etc but I feel it is better if they can choose from a list of account numbers and therefor not need to validate...

You can have as many selection fields as you want. Do you know how to create them?

Umm if the users want it to look like a spreadsheet then let them use Excel. You can have pull down lists in Excel cells if you want.

But there are advantages to using a database. Don't negate those advantages by using a datasheet to simulate a spreadsheet. I can't really imagine what advantages that would give.