My Data Isnt transferring over in one of my tables

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Christene - 04 Feb 2006 18:25 GMT

I was trying add some fields to my form and I must of hit something wrong
because now none of my information will transfer over to my form or report
from the table. I am very confused and in need of help.

Thanks

Reply to this Message

Steve Schapel - 04 Feb 2006 20:40 GMT

Christene,

In design view of the form, have a look at the Properties, and see what
is entered for the Control Source property. I assume this should be the
name of the table, or a query which is based on the table. Is this set
up correctly?

Signature

Steve Schapel, Microsoft Access MVP

> I was trying add some fields to my form and I must of hit something wrong
> because now none of my information will transfer over to my form or report
> from the table. I am very confused and in need of help.
>
> Thanks

Reply to this Message

John Vinson - 04 Feb 2006 22:46 GMT

>I was trying add some fields to my form and I must of hit something wrong
>because now none of my information will transfer over to my form or report
>from the table. I am very confused and in need of help.
>
>Thanks

Sometimes the form's Recordsource query doesn't change to reflect
changes made in the table; and certainly, adding a field to a Form
will NOT change the table. Remember the Form is just a window, a tool
for editing table data; it's not the data storage medium!

View the Form's properties in design mode, and click the ... icon by
the Recordsource property (first line on the Data tab). Make sure that
the fields you're expecting are listed in the form's Recordsource and
you should be ok.

John W. Vinson[MVP]

Reply to this Message