My Data Isnt transferring over in one of my tables

G

Guest

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
 
S

Steve Schapel

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?
 
J

John Vinson

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]
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top