展開したサブデータシートがフォーム表示になってしまう

%3CLINGO-SUB%20id%3D%22lingo-sub-2324345%22%20slang%3D%22ja-JP%22%3EExpanded%20sub-datasheet%20becomes%20form%20display%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2324345%22%20slang%3D%22ja-JP%22%3E%3CP%3EHello.%3C%2FP%3E%3CP%3EI%20am%20troubled%20because%20I%20do%20not%20know%20how%20to%20use%20it.%3C%2FP%3E%3CP%3EIf%20you%20are%20creating%20a%20form%20and%20set%20%5BSplit%20form%20direction%5D%20to%20%5BDatasheet%20down%5D%20and%20%5BExpand%20sub%20data%20sheet%5D%20to%20%5BYes%5D%2C%20the%20part%20opened%20in%20the%20sub-data%20sheet%20will%20be%20a%20form%20form%20instead%20of%20a%20datasheet.%E3%80%80%E3%80%80In%20fact%2C%20the%20form%20is%20already%20displayed%20as%20a%20subform%20in%20the%20details%20section%2C%20and%20there%20is%20no%20point%20in%20seeing%20it%20here.%3C%2FP%3E%3CP%3EI%20want%20to%20solve%20this%20problem.%E3%80%80What%20part%20of%20the%20sub-datasheet%20is%20displayed%20in%20a%20form%20in%20a%20table%3F%20Or%2C%20what%20part%20of%20the%20sub-datasheet%20should%20I%20specify%20a%20form%20name%20for%3F%3C%2FP%3E%3CP%3Ethank%20you.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2324345%22%20slang%3D%22ja-JP%22%3E%3CLINGO-LABEL%3E2016%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EAccess%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2328987%22%20slang%3D%22en-US%22%3ERe%3A%20%E5%B1%95%E9%96%8B%E3%81%97%E3%81%9F%E3%82%B5%E3%83%96%E3%83%87%E3%83%BC%E3%82%BF%E3%82%B7%E3%83%BC%E3%83%88%E3%81%8C%E3%83%95%E3%82%A9%E3%83%BC%E3%83%A0%E8%A1%A8%E7%A4%BA%E3%81%AB%E3%81%AA%E3%81%A3%E3%81%A6%E3%81%97%E3%81%BE%E3%81%86%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2328987%22%20slang%3D%22en-US%22%3ESorry%20but%20the%20auto%20translate%20from%20Japanese%20doesn't%20make%20a%20lot%20of%20sense.%3CBR%20%2F%3EMost%20developers%20recommend%20that%20subdatasheets%20should%20not%20be%20used%20as%20they%20badly%20affect%20database%20performance%20and%20they%20can%20be%20confusing%20to%20end%20users.%20Much%20better%20to%20use%20subforms%20jnstead%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2329269%22%20slang%3D%22ja-JP%22%3ERe%3A%20Expanded%20sub-datasheet%20ends%20up%20in%20form%20view%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2329269%22%20slang%3D%22ja-JP%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1007894%22%20target%3D%22_blank%22%3E%40isladogs%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20isladogs.%3C%2FP%3E%3CP%3EI%20seem%20to%20have%20overconfidence%20in%20automatic%20translation.%20%3CBR%20%2F%3E%20So%2C%20Japanese%20with%20correct%20grammar%20is%20difficult%20even%20for%20Japanese...%3C%2FP%3E%3CP%3E%3CBR%20%2F%3EI%20know%20sub-datasheets%20have%20a%20negative%20impact%20on%20performance.%20%3CBR%20%2F%3E%20Don't%20worry%2C%20the%20one%20I'm%20developing%20this%20time%20doesn't%20require%20high%20performance.%3C%2FP%3E%3CP%3EI'm%20having%20trouble%20with%20the%20sub-datasheet%20part%20not%20being%20displayed%20in%20the%20datasheet%2C%20but%20in%20the%20form.%20%3CBR%20%2F%3E%20(Probably%2C%20in%20the%20case%20of%20automatic%20translation%2C%20I%20think%20that%20I%20could%20not%20read%20here%20and%20it%20was%20not%20transmitted)%3C%2FP%3E%3CP%3EI%20want%20to%20know%20where%20I%20can%20choose%20how%20to%20display%20the%20sub%20datasheet.%20(Data%20sheet%20%2F%20form)%3C%2FP%3E%3CP%3EActually%2C%20as%20an%20idea%20that%20goes%20one%20step%20further%2C%20I%20want%20to%20switch%20form%20names%20with%20VBA.%20%3CBR%20%2F%3E%20I%20searched%20on%20the%20net%2C%20but%20it%20didn't%20come%20out.%20(in%20Japanese)%3C%2FP%3E%3CP%3EThank%20you.%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

こんにちは。

使い方が分からず困っております。

フォームを作成しており、[分割フォームの方向]を[データシートを下に]、かつ、[サブデータシートの展開]を[はい]にした場合、サブデータシートで開かれた部分がデータシートではなく、帳票フォームになってしまいます。  実は、その帳票フォームは既に詳細セクションでサブフォームとしても表示しているものであり、ここで表示されても意味がありません。

この問題を解決したいです。 サブデータシートの表示をテーブルでなくフォームにしている部分を教えてください。あるいは、サブデータシートにフォーム名を指定する部分を教えてください。

ありがとうございます。

6 Replies
Sorry but the auto translate from Japanese doesn't make a lot of sense.
Most developers recommend that subdatasheets should not be used as they badly affect database performance and they can be confusing to end users. Much better to use subforms jnstead

@isladogs 

Thank you isladogs.

I seem to have overconfidence in automatic translation.
So, Japanese with correct grammar is difficult even for Japanese...


I know sub-datasheets have a negative impact on performance.
Don't worry, the one I'm developing this time doesn't require high performance.

I'm having trouble with the sub-datasheet part not being displayed in the datasheet, but in the form.
(Probably, in the case of automatic translation, I think that I could not read here and it was not transmitted)

I want to know where I can choose how to display the sub datasheet. (Data sheet / form)

Actually, as an idea that goes one step further, I want to switch form names with VBA.
I searched on the net, but it didn't come out.(in Japanese)

Thank you.

@harahire790 

The part that I can't understand is this sentence:
I'm having trouble with the sub-datasheet part not being displayed in the datasheet, but in the form.

 

The screenshot below shows a form with two nested subdatasheets. Is that what you want ...or something else? Perhaps you could upload a screenshot to assist me with understanding.

 

Capture.PNG

 

As already mentioned, I normally avoid subdatasheets.

 

On the issue of renaming forms with code, what have you tried so far?

 

@isladogs 

Please forgive me for my terrible English as usual.
I didn't do anything, but I just set [SplitFormOrientation] to acDatasheetOnBottom and the subdatasheet was in the form view.
My hope is to display all parts of the sub datasheet in a datasheet, or switch to another form if possible. (A little more compact)

ScreenShot.png

Ah I see.

You just want a split form with the bottom part shown as a datasheet and not as a continuous form.

in other words, something like this which I created from the ribbon (More Forms...Split Form). It used a datasheet automatically

 

Screenshot 2021-05-07 072957.png

Sorry. I didn't see your screenshot before my last reply.

I doubt you can achieve that with the built in split form as they are fairly limited in terms of the modifications possible. 

 

You may have more luck with my emulated split form (ESF) which is designed to overcome most of the limitations of the MS version. For an example, see

http://www.mendipdatasystems.co.uk/emulated-split-form/4594398119