advanced microsoft access in london - Forms and multiple tables

Resolved · Low Priority · Version Standard

Forms and multiple tables

Brian has attended:
Access Advanced course
Access VBA course

by - delegate Brian [3 posts] (2007 Feb 16 Fri, 09:25) Reply

How do you create a form which is generated from two or more tables

Version	Date	Location	Places available	Book	Next place rate:
Access Intermediate 1 day course
Version	Date	Location	Places available	Book	Card	Invoice
2003	2008 Dec 9 Tue	Bloomsbury	0	FULL
2002/XP	2008 Dec 11 Thu	Tooting	0	FULL
2003	2008 Dec 18 Thu	Bloomsbury	2	book now	£215	£215
2003	2008 Dec 23 Tue	Bayswater	8	book now	£182	£207
2002/XP	2008 Dec 24 Wed	Tooting	0	FULL
2003	2009 Jan 6 Tue	Southwark	5	book now	£198	£215
Full Schedule: See all 51 Access Intermediate course dates. Bookings currently available until 24th November 2009.

RE: Forms and multiple tables

by - trainer Carlos gold contributer [479 posts] (2007 Feb 20 Tue, 10:01) Reply

Create a form using the wizard.

Select the first table in the Table/Queries combo box

Select the fields to be viewed in the form

Repeat for the second/third tables

Complete the form wizard as normal

Alternatively create a separate form for each table and combine the forms in a separate new form using either the SubForm or Tab controls.

Carlos

· Quick Access Course: Creating a Customer Contact Database in 8 Simple Steps
· MS Access Top Tips: Takeaways From Microsoft Access Advanced Training
· Microsoft Access Courses
· Reasons to Consider Microsoft Access Training
· Access VBA Handling Errors and Debugging Code

Access tip:

Switchboard Startup

An option when you open your Access database that contains all of you tables, forms and queries is only the switchboard is displayed.

To achieve this, select Tools click on Startup. On the right hand side of the Startup screen you are able to select which form you want to open when you open you Access Database. Once you have selected this, there is a check box just below that says "Display Database Window", you need to uncheck this option. Then click ok.

Then when you close you Access database and re open it, the database should open with just the switchboard being shown

View all Access hints and tips

Rate this page: