Duplicating an existing form without importing the data?

  • Thread starter Thread starter MicroSoftie
  • Start date Start date
M

MicroSoftie

I can't figure out how to do this after several attempts.
I want to use the same format/fields but when I try to duplicate it, all the
existing data is pulled in.
There are over 175 entries, each with a dozen or so fields, so it would take
way too long to delete manually.
HELP ?!?
 
Are you copying a form or a table?
If you copy a form it is looking at the same table as the old form, and if
you delete records from the new form they are gone from that table!
Change the control source of the new form to whatever OTHER table you want
to look at, assuming it has the same table structure as the table on the
original form.

If you copy a table (highlight, CTRL C, CTRL V) you get the option of
copying structure with or without data. If you need a blank table, select
structure only. Use that blank table as the control source for your new
form.
Mich
 
"If you copy a form it is looking at the same table as the old form, and if
you delete records from the new form they are gone from that table!"

I discovered THAT the hard way already! I deleted a new form that I tried to
create by copying a previous form's layout because it pulled in all the data
in addition to the fields.
So, now that table's info is gone. Grrrrrrrrrr!

I will give your suggestions a try.
Thank you!
 
"If you copy a form it is looking at the same table as the old form, and if
you delete records from the new form they are gone from that table!"

I discovered THAT the hard way already! I deleted a new form that I tried to
create by copying a previous form's layout because it pulled in all the data
in addition to the fields.
So, now that table's info is gone. Grrrrrrrrrr!

I will give your suggestions a try.
Thank you!
Click to expand...

A Form *IS JUST A TOOL* - a window which lets you display and manage data
stored in a table, or tables.

A Form *does not contain any data*.
Deleting a form will not delete any data.
If you just deleted the form, your data should be just fine.

A Form has a Recordsource property, which defines what data that form
displays. It can be the name of a table, or (more commonly) the name of a
Query or a SQL statement which selects data from the table.

You might want to take a look at some of the tutorials on how to best use
Access:

Jeff Conrad's resources page:
http://www.accessmvp.com/JConrad/accessjunkie/resources.html

The Access Web resources page:
http://www.mvps.org/access/resources/index.html

A free tutorial written by Crystal (MS Access MVP):
http://allenbrowne.com/casu-22.html

MVP Allen Browne's tutorials:
http://allenbrowne.com/links.html#Tutorials
 
Back
Top