Form Fields'values in Insert Query

[billypit]

Hi,
In my project i have one table production.Now i have to make application in which i have to insert new data in table by fields of form made in access.I don't know how to use form field's values in insert query.
i am trying this code but it will not insert data.

INSERT INTO PRODUCTION
VALUES ('([Forms]![customer]![Date_Text])', '([Forms]![customer]![PalletNo_Text])', '([Forms]![customer]![CustomerCode_Text])', '([Forms]![customer]![PONo_Text])', '([Forms]![customer]![ItemNo_Text])', '([Forms]![customer]![Description_Text])', '([Forms]![customer]![ShippingLocation_Text])', '([Forms]![customer]![BatchOrLotNo_Text])', '([Forms]![customer]![Cartons_Text])', '([Forms]![customer]![PcsOrCarton_Text])', '([Forms]![customer]![PartialCarton_Text])', '([Forms]![customer]![PartialCarton1_Text])', '([Forms]![customer]![PartialCarton2_Text])', '([Forms]![customer]![TotalQuantity_Text])', '([Forms]![customer]![ShippedDate_Text])', '([Forms]![customer]![QuantityOnHand_Text])', '([Forms]![customer]![Location_Text])', '([Forms]![customer]![Notes_Text])');


after run these query i will get [Forms]![customer]![Date_Text] in table's first field and same in other fields.
If anyone can help plese try to solve the problem
if u get confused please tell me to explain it more clearly.

[Rabbit]

You have to take out the quotes, the quotes signify that what's between them should be read as pure text. What you're trying to do is tell it to get the value from the control on the form.