Multiple Subforms getting stuck using nav buttons

[Mushroom]

Hello everybody,
A2003 on XP or Vista

I have a tricky problem I can't solve. I have a form with multiple
subforms. The subforms a necessary to show the user various pieces of
information about a project for the purpose of invoicing.

I'm showing the user budgeted labor, actual spent thus far and current
invoices for the project. On top of that, the form is showing the workorders
for each project as well.

The problem occurs when using the built-in find feature or using the
navigation buttons at the bottom. The nav button that causes it is the
'first record' button. What happens is the main form won't move off the
current record and the subforms seem to be refreshing repeatedly and
eventually shuts down Access. When using 'find', it will occasionally work
correctly, then suddenly fail.

This is not really what I had in mind when I thought it up!

I have considered linking to these forms with buttons but that sort of
defeats the usefulness of having it all in front of you when trying to
determine how to apply the invoice.

I was thinking of applying a timer to these subforms to make them complete a
second or so after the main form is located, but I really can't determine
where to start. I'm not exactly an Access newbie but I have been trained
mostly by reading this newsgroup and a few books.

Anybody have some advice?

Thanks in advance,
Tim

 

[Mushroom]

I've narrowed this error down to the code used to highlight a record in the
workorder subform. By disabling the line of code in the subform current
event, the problem is solved. Still not sure why this is causing it. I
suspect it has something to do with the order of events.