Isskint
Slowly Developing
- Local time
- Today, 02:38
- Joined
- Apr 25, 2012
- Messages
- 1,302
Hey all,
Normally i build forms from blank. A colleague asked me about the 'new' view options in form wizard. Not being aware of this, I just went to create a new form using the wizard. The recordsource is a query pulling data from multiple tables. After selecting the recordsource, i am asked how i want to view my data (NOT the layout); By xyz or abc and i can use subforms or linked forms (see attached). When you finish the form, the recordsource is not the selected query but an SQL it has built itself based on the query fields selected.
When did this get added? I have never come across this before. Is there a 'mode' switch to turn this off?
I can see it simplifying the creation of forms in forms but i can't say like the results i am seeing. Sticking to building forms from blank
Normally i build forms from blank. A colleague asked me about the 'new' view options in form wizard. Not being aware of this, I just went to create a new form using the wizard. The recordsource is a query pulling data from multiple tables. After selecting the recordsource, i am asked how i want to view my data (NOT the layout); By xyz or abc and i can use subforms or linked forms (see attached). When you finish the form, the recordsource is not the selected query but an SQL it has built itself based on the query fields selected.
When did this get added? I have never come across this before. Is there a 'mode' switch to turn this off?
I can see it simplifying the creation of forms in forms but i can't say like the results i am seeing. Sticking to building forms from blank
