Forms showing as reports in expression builder

[Timber]

Hi,
I am new to Access and have the following problem.


Under the “WorksSubForm” I have fields “SubContract” & “Step” I am to create a query on the step in which the filtering criteria is value selected in the subcontract. I cannot drill further through the “WorksSubForm” on the Expression Builder; as shown in the attachment, the form is being represented by a report icon instead a form. Please enlighten me on why this is happening and how to make it work. By the way, the “LabourHoursSubForm” is the last subform under “WorksSubForm”.

[CJ_London]

are you sure you do not have reports with the same name as a form and assigned them to a subform control in error? - if you open up all Reports on the above screen what do you see there?

[Timber]

Thanks Ajax for your response. I am certain as i did not create any report yet. Expanding the "Reports" section shows "Loaded Reports" and "All Reports" however these items cannot be expanded anymore as there are no more sub items.

[CJ_London]

OK, sounds like you TeamDiary form has become corrupted in some way. Suggest rebuild from scratch.

[Timber]

sigh, that is what I'll probably end up doing. I'm just curious, does the problem have something to do with the fact that the forms are now basically in 4 levels (i.e. DailyDiary>Teamdiary>WorksSubForm>LabourHoursSubFo rm)?

[CJ_London]

I wouldn't think so, maximum number of levels is 7

One other thing you can do is to decompile your code and then compact your db

here is a link to how to decompile

http://www.access-programmers.co.uk/...ight=decompile

[Timber]

Ok. Thanks a lot Ajax.

[Timber]

Update. I've redone the entire file from scratch but the problem persists. Please help.

[CJ_London]

I am now away for a week with limited access to internet so regret someone else will need to help - if you don't get a response on this thread for a couple of days suggest you start a new thread, but provide a hyperlink back to this thread so you don't get all the same suggestions

[IrogSinta]

This is something we may have to look at to figure out. Can you upload a copy of the db with the problem forms? Just make sure to not include any private data any table.

Ron

[Timber]

Hi Irog. Thanks for replying. I have attached a screenshot of the one completely redone file. I have changed the names a bit. This is the file (i have to put it in zip because the current size is 1.4MB and it exceed the limit of this forum):A.1.zip

[Timber]

Any ideas why this is happening? Please help guys.

[IrogSinta]

Hi Timber,
Sorry about the delay in getting back to you but I somehow missed your response last week. If you hadn't followed up, I would have missed this completely. Anyway, I confirmed what you said about not being able to see anymore details in the expression builder once you've gone 3 levels deep. I even created a blank database with just 3 forms and a textbox in the innermost form and I could not see the textbox either in the expression builder because the innermost form shows up with a different icon and no details.



I know in Access 97, you could only go 2 levels deep but my understanding was that you could go 7 levels in Access 2013. I will continue to research this but right now you'll just have to manually enter the reference to your control the long way. So if you want to refer to WorkHours from a query , you would have to type in:

Forms![frmRptReportDate]![subfrmRptTeam].Form![subfrmRptTeamWork].[Form]![subfrmDetProductiveHours].[Form]![WorkHours]

Hopefully I or someone else will have a better answer later on.

Ron

[June7]

I seldom use the expression builder but I've never built forms more than 3 deep. Also my understanding 7 levels is possible and think I have seen 5 used. Seems to be a bug in the expression builder.