Form sql statement changing form name

[melanieh]

I have a form called "Add Product Details" in which there are areas where I have SQL statements that lookup a value based upon a previous box on the form. The SQL statements are [Forms]![formname]![boxname]

For some reason on the Price...... I can add the formname to the SQL statement but each time I open the form, the form name within the SQL statement gets removed and replaced with the word "form". Why is it donig that?

Here is the SQL statement: (dd Product Details is the form name and ID is the previous text box)

SELECT Price1.Price, Price1.WidthxHeight_ID FROM Price1 WHERE (((Price1.WidthxHeight_ID)=[Forms]![Add Product Details]![ID]));


Thank you for any help!!

 

[melanieh]

Database File

Here's the file:
Open Add Product Details form... it works ok the first time, then when closed and opened again it loses the form name.

Thanks!!

 

[melanieh]

I figured out the one error. I had to redo the SQL statement to change the path to the subform.

Still stumped on a similar error on another one. I have it pick up something on the form, but then add a couple things to it. Seems to still not have a correct path.