Please help!

[Rob]

I have got into serious (job threatening!) trouble with
two access mdb tables. One is the full table of
contents, the other is a partial table but with a working
form used to search through.

I want to either merge the full table into the partial
table and thus use the form on the full table or copy the
form over to the full table for the same effect.

Both tables are exactly the same apart from one has more
enteries than the other.

Please help me!

 

[Cheryl Fischer]

Have you tried changing the RecordSource property of your form from the
partial table to the full table?

 

[Guest]

How do I do that?

-----Original Message-----
Have you tried changing the RecordSource property of your form from the
partial table to the full table?



--

Cheryl Fischer, MVP Microsoft Access
Law/Sys Associates, Houston, TX





.

 

[Pavel Romashkin]

Back up the database!!!
Then, follow Cheryl's advice.
What you may want to do is to replace the record source of your form to

SELECT * FROM Table1 UNION SELECT * FROM Table2

replacing * to the columns you need (leave it if you use all of them),
and replacing Table1 and Table2 with names of your table.
You can do this by opening the form in Design view, opening its property
sheet and typing into the Record Source on the Data tab.

Pavel

 

[Cheryl Fischer]

- Open your form in Design View
- Click the Properties icon - or click Alt-Enter
- A Properties Sheet will open. Click the tab labeled "Data"
- Record Source is the first property listed.
- Insert the name of the full table in the property, or click the
downward-pointing arrow at the right edge of the property and select the
table from the list.

If the field names in your partial table and your full table are EXACTLY the
same, your form should work the same as it did before the change in Record
Source. However, if your form has controls on it (such as a combo box)
which reference the partial table or code which references the partial
table, you will need to change these.

 

[Rob]

Dear God, thank you!

Thank you

 

[Cheryl Fischer]

You're welcome and good luck with your project.

 

[Dirk Goldgar]

You're welcome and good luck with your project.

Cheryl, you've been promoted!

 

[Cheryl Fischer]

<G> I think that position is already filled!