access database course - Access forms

Resolved · Low Priority · Version Standard

Access forms

Angie has attended:
Access Intermediate course

by - delegate Angie [1 post] (2007 Dec 4 Tue, 16:57) Reply

How do you show tabs across a main form(not controls) to access sub forms from the main form

Version	Date	Location	Places available	Book	Next place rate:
Access Advanced 1 day course
Version	Date	Location	Places available	Book	Card	Invoice
2003	2008 Dec 19 Fri	Bloomsbury	5	book now	£219	£235
2003	2008 Dec 24 Wed	Bayswater	0	FULL
2003	2009 Jan 7 Wed	Southwark	7	book now	£203	£230
2003	2009 Jan 14 Wed	Bloomsbury	8	book now	£187	£224
2003	2009 Jan 23 Fri	Bloomsbury	7	book now	£203	£230
2003	2009 Jan 28 Wed	Bayswater	8	book now	£110	£205
Full Schedule: See all 44 Access Advanced course dates. Bookings currently available until 25th November 2009.

RE: Access forms

by - trainer Pete platinum contributer [803 posts] (2007 Dec 13 Thu, 11:59) Reply

Hi Angie, Thank you for your post, on considering your post I can only work out that you require command buttons on your form to enable you to open other forms, if this is not the case please feel free to respond. In order to create a command button on a form in Access, you open the Form in Design view, ensure the toolbox is selected and visible. On the toolbox you will see an icon which represents the Command Button, a tooltip will confirm this. Click on this icon and in your form drag to draw a rectangle, follow the instructions to select the form you wish to display, whether you require a graphic or text on your button. Change to Form view and test your button. To create additional buttons you will need to follow the steps again. I hope that helps, best regards Pete.