Tables

H

Harvard

I have a table with some information in it. Then I decided to create a form,
so that I wouldn't have to enter all that data into the table directly.
Here's the problem, when I enter information in the form, it doesn't show up
in the table. Say I entered a Primary key of 5 into the form, and then some
text in the text field...none of it shows up in the table. So I decide to
enter a Primary Key of 5 in the table, but then it won't let me because it
says it would create duplicate value. So does anyone know a way to get the
values that i entered in the form to actually appear in the table?
 
J

Jeanette Cunningham

Harvard,
The primary key is something that access manages for you automatically, you
shouldn't enter anything in it. Set the textbox for the primary key to
Visible - No (property dialog | Format tab)
On the form click the new record button and enter text in the textbox, click
the new record button again and enter the next record.
Close the form using the red X in top right hand corner.
You should be able to see those 2 records in the table.

Jeanette Cunningham
 
J

John W. Vinson

I have a table with some information in it. Then I decided to create a form,
so that I wouldn't have to enter all that data into the table directly.
Here's the problem, when I enter information in the form, it doesn't show up
in the table. Say I entered a Primary key of 5 into the form, and then some
text in the text field...none of it shows up in the table. So I decide to
enter a Primary Key of 5 in the table, but then it won't let me because it
says it would create duplicate value. So does anyone know a way to get the
values that i entered in the form to actually appear in the table?
Click to expand...

Does it not show up in the Table (when you open the table itself in datasheet
view) or do you just not see it in the Form after it's been entered? If the
latter, perhaps you have set the Data Entry property of the form: doing so
will let you add new records but existing records will not be shown.
 
J

John W. Vinson

It doesn't show up in the table (datasheet view) at all.
Click to expand...

In that case.. what is the name of the table? What is the Recordsource
property of the form?
 
Top