If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
form creation
Is there a way of creating a form which diplays
information from differnet tables in one form |
#2
|
|||
|
|||
form creation
Sure...you can use a query that links the tables together
as the form's record source. -----Original Message----- Is there a way of creating a form which diplays information from differnet tables in one form . |
#3
|
|||
|
|||
form creation
Yes, base the report on a query and include multiple tables in the query. I
would expect that almost every form you build would be built in this way if you have truly structured your tabels as a standard relational database. Rick B wrote in message ... Is there a way of creating a form which diplays information from differnet tables in one form |
#4
|
|||
|
|||
form creation
That should have said ... base the FORM on a query...
"Rick B" wrote in message ... Yes, base the report on a query and include multiple tables in the query. I would expect that almost every form you build would be built in this way if you have truly structured your tabels as a standard relational database. Rick B wrote in message ... Is there a way of creating a form which diplays information from differnet tables in one form |
#5
|
|||
|
|||
form creation
yes thats correct, however when I do that I change my
record source and then all other fields that I need to use become Inoperable. I guess I need so sort of way to include both sets of information is that possible? P.S. thank you for the reply. -----Original Message----- Sure...you can use a query that links the tables together as the form's record source. -----Original Message----- Is there a way of creating a form which diplays information from differnet tables in one form . . |
#6
|
|||
|
|||
form creation
Yes you are correct but I need this for for data entry and
a select query will not let me input new information. Is there something that I'm missing? Thank-you for your reply -----Original Message----- That should have said ... base the FORM on a query... "Rick B" wrote in message ... Yes, base the report on a query and include multiple tables in the query. I would expect that almost every form you build would be built in this way if you have truly structured your tabels as a standard relational database. Rick B wrote in message ... Is there a way of creating a form which diplays information from differnet tables in one form . |
#7
|
|||
|
|||
form creation
This is what sub forms are for.
I will assume that there is a common field in the two tables. Just create a form (subform) for the information from the second table and then drag and drop the new form into the original form. Take a look at the properties of the sub form and be sure that the link fields are correct. That should do it. HTH Byron -----Original Message----- Yes you are correct but I need this for for data entry and a select query will not let me input new information. Is there something that I'm missing? Thank-you for your reply -----Original Message----- That should have said ... base the FORM on a query... "Rick B" wrote in message ... Yes, base the report on a query and include multiple tables in the query. I would expect that almost every form you build would be built in this way if you have truly structured your tabels as a standard relational database. Rick B wrote in message .. . Is there a way of creating a form which diplays information from differnet tables in one form . . |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Searching Records | Melissa Lambino | New Users | 6 | July 20th, 2004 04:51 AM |
Modal form | Praveen Manne | Using Forms | 1 | July 6th, 2004 10:49 PM |
Modal form | Praveen Manne | General Discussion | 1 | July 6th, 2004 10:49 PM |
Invoicing Form Creation | Brook | Using Forms | 3 | June 19th, 2004 08:23 AM |
surely a form with a ListBox can be used in a query? | 1.156 | Running & Setting Up Queries | 14 | June 2nd, 2004 04:54 PM |