Hello,
I would like to ask for some advice regarding a problem I keep having when trying to construct a form on Access (2016). The relational database I have built contains 9 tables.
When using ‘wizard form’: I can only add 3 to 4 tables to my form order to get to the step ‘how to view your data’ and select ‘by [name table]’. Once I add more tables to the form, this option is skipped and the end result of my form is not at all what I would want it to be. Moreover, when I select 4 tables or more my form ends up completely blanc in ‘form view’ while the variables do show up in ‘design view’.
I tried to overcome this problem by starting from ‘empty form’, but the same problem occurs. Once I add one (what seems to be a completely random) variable too many, the form is shown as completely blanc in ‘form view’ while ‘design view’ does show the variables. I have no idea how to overcome this problem..
My final question concerns the use of ‘forms with subforms’ or ‘linked forms’. I have heard of many arguments pro and contra each of those but is there a clear argument to choose one or the other?
Thank you very much!