#Error when requering subform

Hello all,

I have just run across a very strange problem. I have a main form with two subforms in it. One for personel and one for equipment.

I have a button that opens another form that allows the user to add items that are in a pull down that is in both subforms.

Upon closing the "Add Items" form, I have a requery command that requeries the combo boxes in each subform so that added itmes will appear.

When that happens, all of my calculated fields in the subquery of my subforms have #Error in the field and I am basically dead in the water.

If I close my main form and reopen it, everything is fine.

I searched the Knowledge base and MS admitted that there is a problem where the sub query goes into a continuous loop after a requery command, but NO FIX!

Any ideas will be greatly appreciated.

Thanks,

Bobby

To the 50 members that looked at my question, but drew a blank, I thank you for at least reading it and seeing if you could possibly help me out.

I still hope for a solution, but wanted to thank you guys (and gals) so far.

BobbyLand

Hi,

Is this issue still topical?
If yes then is that possible to upload the file.
I am ready to help you, but this is really strange and I need to have a look to investigate the problem that causes the #Error.

TBÁrpi