Dennis,

There are ways to use Excel's VBA Form as a FrontEnd Data Entry Form. By
using the reference DAO or ADO, you can have the Access as back end database.


Ronin

"Dennis the Safety Nerd" wrote:

How do I create a custom form for data entry
It should have drop down boxes to select from and preferably have data on 3
work sheets.
It would also help if there were an auto number field like access uses. I
can't figue access out so I need to use excell.