form doesn't transfer data to table

R

Rick

First, please note I am a new user of Access.
I was given a database that had a table. I designed a form for entry of the
data, to make it easier than scrolling across the table.
However when I enter the information on the form, it does not transfer to
the database. So basically the form is worthless.
Does anyone know what I did wrong?
Thanks
Rick

[email protected]
 
J

John W. Vinson

First, please note I am a new user of Access.
I was given a database that had a table. I designed a form for entry of the
data, to make it easier than scrolling across the table.
However when I enter the information on the form, it does not transfer to
the database. So basically the form is worthless.
Does anyone know what I did wrong?
Click to expand...

Probably you didn't set the Recordsource property of the form to your table,
or perhaps you didn't set the Control Source properties of the form controls
to the fields in the table. How did you create the form?

Note that you can use the "Auto Form" button when you have a table open in
datasheet view to create a very basic simple form bound to the table.

John W. Vinson [MVP]
 
R

Rick

I wondered if I needed to do something to link the info i was entering to the
data in the table. I'll try that.
Thanks!
 
Top