Assuming that you have your tables already set up, simply bind them to the
Access form. There's a wizard for automatically creating bound forms. If you
look at the sample files (the Northwind database) that came with Access (you
can find them in the help menu), the example is similar to what you need.
Instead of printing the form, use a report, which can be made from the form,
but gives you additional features.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads: http://www.datastrat.com http://www.mvps.org/access