Copying Forms

[MitziUK]

I have a table for cars and a table for lorries. I have a wonderful form I
have created using tabs for the cars, but now I want to transfer it over to
the lorries.

I have copied the form, but how do I get the control source to point to the
right table please?

...I know I should have created just 1 table but, as the saying goes don't
run before you can walk...doh. It's too late to transfer them into 1 able
now so the table structure has to stay - The database has grow considerably.

[Douglas J Steele]

Look at the Properties for the form. Find the DataSource property (it should
be the first property on the Data and the All tabs). Change it.

Are there differences between the two tables? If you're referring to fields
that exist in the Cars table but not the Lorries table, you'll have problems
with the form. If the fields are the same, why can't you simply load the
data from the Lorries table into the Cars table, using an Append query?

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)

"MitziUK" <Mit...@discussions.microsoft.com> wrote in message
news:0A127CAE-58BC-4CB8...@microsoft.com...

[MitziUK]

I cannot apend the lorries table to cars table as the lorries table has other
forms dependant on it. I could possible do it the other way around by
appending the cars to the lorries.

I have changed the control source but the form now shows #Error. Why?

Karen (mitziUK)

[Douglas J Steele]

Impossible to say without more details!

Is #Error in every control?

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)

"MitziUK" <Mit...@discussions.microsoft.com> wrote in message

news:7786AB29-CACF-487F...@microsoft.com...