Requery and Caching problem

[TimK01]

I have a form Form1, with a subform Form1sub. On the subform I have a listbox which is populated by some sql based on fields on form 1

I have abutton on the subform that opens a new window (modal) and allows the user to select a new type of record to add. This new record should appear in the listbox. I have code in the end of the modal windows code that requerys theform expecting the newly added data to appear.

Id doesnt, so I addd buttons to the subform to requery the subform and the parent form, still the data doesnt appear.

I scroll forward then back on the main form and the data still doesnt appear

I close the rorm and reopen it at the correct record and the data does appear

My guess is that the new record is cached somewhere. can anyone confirm this and or offer a solution that will get the datd to appear when it is added.

Tim

 

[ZmrAbdulla]

Hi,
Change the part of the Code of Command Button to this

stDocName = "YourNewFormName"
DoCmd.OpenForm stDocName, , , , acFormAdd, acDialog
Me.YourMainFormName.Requery
Me.YourSubFormName.Requery

Regards

Zameer Abdulla

http://www.geocities.com/zameerabd/

http://www.mtkhoory.com