Search results

I have a continuous form with field "Attachment" which will count all attachment relevant to the ID of the form. I was able to count the attachment with this =Nz(DCount("EntryDocID","tblPoolAttachmentDetail","EntryDocID = " & [tbID].[Value]),0) but at the end of the row where you will see the...

This trick solve the issue. In order to not let the form throw an error, first execute the docmd.browseto (browse to second tab) prior to Forms![Nav Form Attachment]![NavigationSubform].Form.[Pool eFile Attachment].visible=True.

Did you mean a subnavigation form of the current nav form? Or may be not.

I didn't get your point clearly nor paying attention to it. May be I was too carried to receive an answer seeing a code directly. And beside, this is my first project with MS Access. Your warning was right I really didn't expect it behaved that way. Anyhow, now you've explained it directly it...

Now I spotted the problem. Just to share my experience, which is i know some people may find it obtuse. Anyway. My navigation form has a two tabs and this form is designed to pop-up once the user click on a control (i.e. textbox) which I set the on click event on it. I noticed that when you...

@Galaxiom That would be a great hint. I'll try your suggestion

@Pat Hartman Forms!yournavformname!thesubformcontrolname.Form!y This example you've given me would not work. As i've tried interchanging "! and ." prior posting here. I was googling with regards to this but all examples are referred inside the navigation form like my code posted above.

I'm not familiar regarding "the BUILDER or use a query to paste the path". Kindly explain further.

What is the appropriate path to reference a sub-subform in a navigation form from outside form. This path work if you are in the navigation form, but not on outside form. Forms![Nav Form Attachment]![NavigationSubform].Form.[Pool eFile Attachment].visible=True