Access 2000 Northwind Orders Form button for "Add New Product"

[plang99]

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.
plang99@yahoo.com

 

[WHM]

plang99,
I would guess that you are using Win2000Pro? If so check this link out:

http://support.microsoft.com/directory/article.asp?ID=KB;EN-US;Q300216

If you are using a mixed OS Network Be vary careful. It seems MS did not make their new OS compatible with all of their products.

If you are not using Win 2000 Pro, or this does not solve your problem (It did not solve mine) try these steps:

1st Make SURE that you save the record before you requery (I know, sounds silly)

2nd (and this is ugly!) Put your re-query inside a do loop that does not exit until the new record appears. I "Up Graded" to 2000 Pro a while back and have had similar problems ever since. The only solution for my application that I have found is the ugly Loop solution because my program cannot continue execution until the new record is located.

If you find a less ugly solution, PLEASE let me know.

Hunter_McCray@HotMail.Com


LOL

Hunter

 

[plang99]

Hunter,
I went to the MS for the link you gave me. I do have Jet40SP5_9xnt installed and MDAC 2.61.

I would have to look up on how to do the loop, I have only done it in a class.

I do find that F0 pressed when back in the SubForm does a re-indexing. (I remembered it from 1-2-3, Excel, etc.)

I'll let you know how the loop comes out.

Paul