minz130
03-17-2008, 10:08 AM
Hi, please can any one help me on this small situation. I have an order form but because my values held in a field in the form is not being saved into my order table, i have been told to insert the fields from my order form as well as my products table and hide the products field and set my order field to be equal to the products field so it can save the value in the order table. please can anyone help me type and equation into the field so it does that. Currently i have typed: =[2Products].[Description] into the order field. But this does not work as it comes up with an error, "#Name!". Does anyone know how to help me. Please look at the imageihave attached. Many thanks.