In Access 2000 Northwind.mdb I have a "Enter new Product" Button on Orders Form and on the "New Product" Form (based on qryProducts) I have a "Save" and "Close Form" button.
When back to Orders Form and in the Subform the New Product does not show up.
I have tried to add code to both buttons on the "New Products" Form like DoCmd.Requery, DoCmd.Save acQuery, "qryProducts".
Neither works.
Any suggestions.

This question was also posted in the Access forum. Please post any replies <A target="_blank" HREF=http://www.wopr.com/cgi-bin/w3t/showthreaded.pl?Cat=&Board=acc&Number=74330&page=0 &view=collapsed&sb=5&o=186&fpart=>in this thread</A>--Charlotte