Software

Ask something
Discussion Locked

Access: Adding tables to existing form

0 helpful
7 replies

by jenir8272 1 view

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
I have 2 tables (w/ relationship) that I created, made a form through the wizard pulling this information in. I tried to create a 3rd table to add. Even after forming the relationships I cannot get the form to allow the fields from that 3rd table. Can you not add more tables to be used with an existing form? IF you can I'd love some direction on what I need to do??

7 replies

by richtee

I am not sure or clear of what exaclty you are trying to do. However, You can create a query using the three tables (and their relationships). Then use the query as the data source for the form. You will be able to access all the fields of the 3 tables.

by jbruggeman

Open the form in design view. Go to view, properties. Your control source is where the information is being drawn from. Click on the ... and it will take you into a query that was automatically made when you used the wizard. Modify the query to include the third table. This will prompt you that a change has been made. Accept this and you are ready to go.

by stillatit

The form is based on a query. Either you created the query separately, or you used the query builder to create it on the fly.

Looking at the form in design view, right-click on the box in the upper left corner (at the intersection of the rulers).Select Properties. Select the Data tab. Click on Record Source. Now click on the ... button to invoke the query builder. Right-click in the top window of the query builder, select show table. You can now add a table to the query. Add the fields youwant to see by double-clicking in the file windows. Close the builder, saving the changes to the query. Close the field box, then re-open it in the View menu. You should see your new fields along with the original ones.

Remember that you ONLY seethe fields in your query, not everything in the tables.

Good luck.

This discussion is closed to new replies.