Order date logging

[Shari]

I have a database set up that has each one of my customers listed on a
different form. For each customer, I would like to be able to enter Date
Ordered, Date Completed, and Date Faxed. I have seen this done at the bottom
of a form, where there is a box like structure, and there is one line for
each order, but different columns for the categories. Everytime you hit
enter, it would add another line automatically. How do I go about setting
this up? Thank you.

 

[Roger Carlson]

If you truly have a different form for each customer, you need to stop here
and redesign your database. Off hand, I'd suggest a Customer table and an
Order table. You can then enter your customer and order information into a
Form/Subform arrangement.

On my website (www.rogersaccesslibrary.com), is a small Access database
sample called "FormSubform.meb" which will illustrates how to do this. My
sample has Products/Parts rather than Customers/Orders, but the setup is the
same.

--
--Roger Carlson
MS Access MVP
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L