Search results

I have a question on my form: I have one text box that combines several items in an expression to make a specific ID. Then, I have a second text box that I want to take the ID from the first text box and lookup the price on a table. (I have a table with the IDs and the prices for each ID...

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.

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!!

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...