Appending from subform

[strikeuk]

Please help me guys, basically i'm having a problem appending a a date value from a subform into a table. My master form "F_ReceivingProcessParts" is running this query "Q_ReceivingDetailSub" from a button command using "DoCmd.OpenQuery "Q_ReceivingDetailSub"". Here is my SQL code for your reference.

INSERT INTO T_ReceivingProcess ( [date] )
SELECT [Forms]![F_ReceivingProcessPartsSub]![txtDate1] AS Expr1;

I'm always getting the "Enter Parameter Value" box and if i click on cancel it says that it can't find the name "Forms!F_ReceivingProcessPartsSub!txtDate1" in the expression.

Thanks

 

[pbaldy]

The syntax for the subform is wrong, since it's a subform. Here's a good reference:

http://www.mvps.org/access/forms/frm0031.htm