I am new to Access and am using Order Entry Template that comes with Office 20002.
When I enter a product in the "order form " the unit cost is blank and therefore the line total gives " #error".
I did have it working some months ago but I have changed somthing, possibly in the "products table".
Any help greatly appreciated!!
Gordon

Gordon:

Let's say you changed one of the field names in the product table from ProductName to Product Name.

Well, your form is looking for ProductName.

Find out the name of that field in the table. Go to your form in design view and double-click on the control that's returning the error. Go to the data tab and make sure the field name is right.

~Dreamboat~
TheWordExpert (http://www.thewordexpert.com)

Hi
I checked the field name and its OK, any other ideas?

how do I find the order entry template for 2007 vista?

I have an older versiion but want the new one on my laptop. I cannot find it anywhere. I did find customers orders database but there is no onvoice there and it does seem different.

thanks