Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
How do I display fields from two different tables in one form? 1
- Thread starter fish919
- Start date
-
1
- #2
FancyPrairie
Programmer
You could join the tables in a query. Set the Record Source property of the form to the query and set the Recordset Type property of the form to Dynaset (Inconsistent Updates)
How are the tables related? And are you using 2007?
If the tables are related, you could do what fish919 said, and make a query.
But this bodes a different question. If all the fields are required to be on one form, are they all a one-to-one relationship? If that is so, then it will be very easy to make a query to combine them, then create the form off of that.
If the tables are related, you could do what fish919 said, and make a query.
But this bodes a different question. If all the fields are required to be on one form, are they all a one-to-one relationship? If that is so, then it will be very easy to make a query to combine them, then create the form off of that.
- Thread starter
- #4
Thanks FancyPrairie
I joined the two tables in a query and changed the Properties in the table and that did it, I can now enter data in this form. (Thank you) Not shore if you will be able to answer this but how do I record the ID(name) field of both tables?
Hear is what I mean Both tables have the same Unique ID or name. In the form I make only one ID visible I used VBA to copy the ID field to the duplicate ID (name) field. It works the duplicate information appears in the form but when I go back to the tables and check the field that contains the ID (names) the filed is blank.
To copy the field all I am doing is creating a memory space and then setting it equal to the field I would like the copied text to appear in.
Please let me know if I am clear or not.
I joined the two tables in a query and changed the Properties in the table and that did it, I can now enter data in this form. (Thank you) Not shore if you will be able to answer this but how do I record the ID(name) field of both tables?
Hear is what I mean Both tables have the same Unique ID or name. In the form I make only one ID visible I used VBA to copy the ID field to the duplicate ID (name) field. It works the duplicate information appears in the form but when I go back to the tables and check the field that contains the ID (names) the filed is blank.
To copy the field all I am doing is creating a memory space and then setting it equal to the field I would like the copied text to appear in.
Please let me know if I am clear or not.
- Thread starter
- #5
- Thread starter
- #7
Thanks Dontremb,
I would except the entire Database is based on a paper form that date back some 30 years. So over the years things that were next to each other moved to other parts of the form and so parts became so large I gave them there own Table
I would except the entire Database is based on a paper form that date back some 30 years. So over the years things that were next to each other moved to other parts of the form and so parts became so large I gave them there own Table
- Status
Similar threads
- Locked
- Question
