access+training+london - add table existing form

Public Schedule Face-to-Face & Virtual Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Access Training and help » access+training+london - Add a table to an existing form

access+training+london - Add a table to an existing form

resolvedResolved · Low Priority · Version Standard

Amy has attended:
Access Advanced course

Add a table to an existing form

Is it possible to add a new table to an existing form?

I've got a form that has quite a lot of fields and controls from two tables and I would like to add another table and use tabs to seperate the information but I don't know whether this would be possible without starting again?

Thank you

Amy

RE: Add a table to an existing form

Hi Amy,

It is possible to add a new table to an existing form. After you have created a form, you can modify its source of data to include or exclude one or more fields, tables, or queries. Note that changing the record source will change the contents of the field list.

Open the form in Design view. Double-click the form selector (form selector: The box where the rulers meet, in the upper-left corner of a form in Design view. Use the box to perform form-level operations, such as selecting the form) then select Properties to open the property sheet and select the Data tab.

Do one of the following:

To include all fields or columns from a single table or query in the record source, click the arrow in the RecordSource property box to select from a list of tables and queries.

To base the form on certain fields, or on more than one table or query, click the Build button next to the RecordSource property on the Form Design toolbar to open the query

Hope this helps

RE: Add a table to an existing form

Thanks very much!

Amy

 

Training courses

 

Training information:

See also:

Welcome. Please choose your application (eg. Excel) and then post your question.

Our Microsoft Qualified trainers will then respond within 24 hours (working days).

Frequently Asked Questions
What does 'Resolved' mean?

Any suggestions, questions or comments? Please post in the Improve the forum thread.


 

Access tip:

Hiding Multiple Table columns

If you want to hide non-adjacent Access table columns. In Datasheet view, open the table that contains the columns you want to hide.

On the Format menu, click Unhide Columns.
In the Unhide Columns dialog box, clear the check box next to the name of each column you want to hide.
Click Close.

This method makes having to use the Hide Columns command repeatedly unnecessary

View all Access hints and tips


Server loaded in 0.08 secs.