Positioning subforms

[msmithtlh]

I have a main form with 4 nested subforms. Everything is working perfectly data-wise. However, users have requested that I make it easier to see the levels. I believe I could do this if I could "manually" position the forms, but can't find any setting for placing them in a certain location on the screen.

Main form name: SUNTAX Header
First subform: BPItems sub
Second subform (nested in 1st subform): BPErrors sub
Third subform (nested in 2nd subform): COItems sub
Fourth subform (nested in 3rd subform): COErrors sub


Looking forward to your assistance. Thanks!!

[June7]

Maybe this will help http://www.fmsinc.com/MicrosoftAcces...edSubforms.asp

[msmithtlh]

The article doesn't talk about the position of the subform on the screen. I'm wanting to set the physical position of the subform.

[June7]

In conventional arrangement a nested subform must be within the frame of its parent form. Form at each level can be sized and positioned so not quite sure what the issue is.

If you want to do not nested, the referenced link demonstrates.

Four levels is getting pretty deep.

[msmithtlh]

You say "Form at each level can be sized and positioned" - that is what I'm not finding. How do I do that? These are all datasheet subforms. I have not been able to find a way to position the subforms.

[June7]

That adds to my confusion. A subform is created by putting a subform container control on another form. The container can have a SourceObject of table, query, form, report. Are you using table as SourceObject?

I think you better provide db. Follow instructions at bottom of my post.

[msmithtlh]

See attached.

[June7]

With nested forms, only the last subform can be in Datasheet view, unless you use tables or queries as the SourceObject. Then have to click the + in left margin to open subform.

I am surprised Access allowed this.

[msmithtlh]

In my form you do have to click the + in the left margin to open the subform. I still need to know how to control the physical location of it. Nothing, so far has addressed my question.

[ItsMe]

Perhaps using a report in Report View is worth consideration.

[msmithtlh]

How would you do data entry on a report?

[ItsMe]

I have not yet found a need to do data entry in more than one form while in DS view. So I do not have an answer for you. I usually use DS or continuous view to display data retrieved. When multiple records need to be added (in a single session/instance) I may provide a DS view. However, I have not found a need for more than one DS view data entry form at a given time.

One option I may employ would be to use a single query using a LEFT JOIN. Fields retrieved from the table on the RIGHT are carefully selected and Indexed so the query is updateable.

Another approach would be to use a subform and VBA. I will place a subform within a mainform and remove the borders from the subform container. The appearance is that the two forms are one. The VBA manages referential integrity.

These approaches are not necessarily suitable for your situation. I only use them for tricky data entry situations I may come across in Back Office situations. Situations where the Workflow, tables, and Queries of the DB are better suited for Operations and thus, more complicated to manage in the Back Office. In short, your issue may, best, be addressed at the table layer.

[msmithtlh]

Please allow me to restate what I said in the beginning. This is working perfectly data-wise. Therefore, I am only looking for a way to change the appearance slightly (if possible) to please the users.

[ItsMe]

Glad to hear that you are not having any issues with your database.

[June7]

I am not understanding your issue. I was able to move each container and position them at the left edge of each parent form. However, with exception of the first subform, position seems to be irrelevant with Datasheet view.

I have never set up multiple nested subforms in Datasheet view. The deepest I've ever nested is form/subform/subsubform and only the deepest is set in datasheet view.