filtered form with continuous subforms not advancing

[suzan24k]

Any fresh testing ideas are welcomed. I have searched the news groups
for quite a few days now and I cannot fish out any more new approaches
to solve.

I am working on a form that has a continuous subform embedded in it.
When creating a new subform record, I am unable to click in the new
subform blank record to advance. If I press the [esc] key, the pencil
goes away and I can advance. Right after entering info for a new
record/form and then I click any field in the "new" record subform
area, I briefly see "Calculating...." in the bottom Status Bar area.
The pencil (indicating the subform record is in Edit and I think not
commited) is still showing. I also cannot use the record selectors to
advance. I cannot figure out where the form is sticking. I have
minimal code with code breaks looking for a stop but it doesn't appear
to be making it to the code. Best I can guess what MIGHT be happening
with that the outer Consultants main form is filtered off a Projects
form using the below code. I don't know if the main form is getting
stuck on a filter that is somehow unresolved.

mini visual aid:

-----------------
-------------------------------------
|Projects | | Project Consultants
|
|form |------>filter call to -->| Form Header
|
------------------ |
------------------------------- |
| | subform listing
| |
| | consultants using
| |
| | Continuous forms
| |
|
------------------------------ |

-------------------------------------
Dim stDocName As String
Dim stLinkCriteria As String

stDocName = "frmConsultants"
stLinkCriteria = "ProjectID =" & Me!txtProjectID

DoCmd.OpenForm stDocName, , , stLinkCriteria, acFormEdit,
acWindowNormal

There is code in the subform and some in the Project Consultants form
but I cannot that any of it ever gets running.

Thank you in advance for any help.

Much appreciation....

Suzan

 

[Guest]

Hi Suzan,

Check the linking between the main form and subform, and check the settings
on the subform...

Damian.

 

[suzan24k]

Words to those whom don't want us to post something that has already
been answered : I guess I had to post something before I could finally
figure out my problem.

Short story answer is I had some code in the subform's AfterUpdate
Event that I moved to the BeforeUpdate. Don't ask me what I was
thinking when I put it there, but moving that code fixed the problem.
And yes, I finally found a post that told me to check this.

Thanks for letting me post here. I may end up finding this resolution
again in the future.

Much appreciation to all those that contribute here. You all are more
valuable than you realize.

Suzan