Now I will create ‘frmNewOrder’ which combines three existing forms together to make an easy to use functional order form. I follow this process to create ‘frmNewOrder’: I create a new form in design view I insert a header and footer and create a header as outlined in the database design with the addition of an order date and order time text box. I edit the control source for the date text box: I edit the control source for the order time text box: I will create a tab control so that the form is separated into three sections to make the interface easier to use: By default two pages will be created within the tab control so I create another page by right clicking the tab control and clicking ‘Insert Page’: I rename the tab control to ‘tabControlNewOrder’, I also rename the sheets ‘pagSelectHost’, ‘pagSelectConsultant’ and ‘pagBuildOrder’; I change the captions of each page to ‘Select Host’, ‘Select Consultant’ and ‘Build Order’ respectively. I then change the formatting of the tab control to match the database design. Now I add the components into ‘pagSelectHost’ as laid out in the database design: The first set of components can be added easily as shown in the screenshot: To insert ‘frmFindHost’ into the page I need to insert a subform: Once I have dragged out a subform using the handles the ‘Subform Wizard’ appears:
Now I will create ‘frmNewOrder’ which combines three existing forms together to make an easy to use functional order form. I follow this process to create ‘frmNewOrder’: I create a new form in design view I insert a header and footer and create a header as outlined in the database design with the addition of an order date and order time text box. I edit the control source for the date text box: I edit the control source for the order time text box: I will create a tab control so that the form is separated into three sections to make the interface easier to use: By default two pages will be created within the tab control so I create another page by right clicking the tab control and clicking ‘Insert Page’: I rename the tab control to ‘tabControlNewOrder’, I also rename the sheets ‘pagSelectHost’, ‘pagSelectConsultant’ and ‘pagBuildOrder’; I change the captions of each page to ‘Select Host’, ‘Select Consultant’ and ‘Build Order’ respectively. I then change the formatting of the tab control to match the database design. Now I add the components into ‘pagSelectHost’ as laid out in the database design: The first set of components can be added easily as shown in the screenshot: To insert ‘frmFindHost’ into the page I need to insert a subform: Once I have dragged out a subform using the handles the ‘Subform Wizard’ appears: