Prev: Save prompt is not working
Next: Calendar Control
From: forest8 on 25 Jan 2010 18:35
Hi

I have created a form which suits my needs.

I made a copy of it since it has many features I needed for another table.

In my copied form, I can't add or make changes to the new form.

How do I make it so I can amend, revise or add new data?

Thank you in advance for your help.
From: Jeff Boyce on 25 Jan 2010 19:05
How have you tried to make changes?

What kind of error messages (if any) are you getting?

Is it a problem with changing the design of the form, or with using the form
to change data in the underlying table?

How is the new form "connected to" the data in the (new) table?

How is it that you have more than one table with similar enough structure
that you can use a copy of a form to attempt data entry? In a
well-normalized relational database, you'd only have ONE table.

More info, please!

Regards

Jeff Boyce
Microsoft Access MVP

--
Disclaimer: This author may have received products and services mentioned
in this post. Mention and/or description of a product or service herein
does not constitute endorsement thereof.

Any code or pseudocode included in this post is offered "as is", with no
guarantee as to suitability.

You can thank the FTC of the USA for making this disclaimer
possible/necessary.

"forest8" <forest8(a)discussions.microsoft.com> wrote in message
news:E8210D69-81FB-4F60-916A-E59470CF8477(a)microsoft.com...
> Hi
>
> I have created a form which suits my needs.
>
> I made a copy of it since it has many features I needed for another table.
>
> In my copied form, I can't add or make changes to the new form.
>
> How do I make it so I can amend, revise or add new data?
>
> Thank you in advance for your help.


From: John W. Vinson on 25 Jan 2010 19:17
On Mon, 25 Jan 2010 15:35:01 -0800, forest8
<forest8(a)discussions.microsoft.com> wrote:

>Hi
>
>I have created a form which suits my needs.
>
>I made a copy of it since it has many features I needed for another table.
>
>In my copied form, I can't add or make changes to the new form.
>
>How do I make it so I can amend, revise or add new data?
>
>Thank you in advance for your help.

Data is NOT stored in the form - it's stored in a Table.

What is the Recordsource (the table behind) each form?
--

John W. Vinson [MVP]
 | 
Pages: 1
Prev: Save prompt is not working
Next: Calendar Control