Making my form depend on my table

[Katy]

I am trying to produce a database that is made up of quite a few tables but
so the information will be seen over two forms. I have produced all the
tables and related them successfully. I have also produced the forms i want
to use. My aim is for people to input information into the database via the
forms, not the tables. When I have tried to do this, the information is
automatically put into the table but when i save the form and the table and
then gone back into the form the information has disappeared from there but
remains in the table.

This is absolutely infuriating and i know i must be missing something
simple. I have changed data entry to 'yes' in the property sheet. I have
noticed that in the relationship dependancies sheet it is telling me that
everything depends on my table but nothing depends on my form. I think this
may be the problem but i can not find out how to change this, it will only
allow me to change relationships between tables!!! AHHH!

I hope this makes sense and that someone can help me, its driving me up the
wall!

 

[Golfinray]

Did you use the form wizard to build the form for you or did you build it
yourself? I would start with the recordsource of the form. It must typically
be the table name. Are you using one table per form or trying to use more?

 

[RonaldoOneNil]

Changing data entry to Yes means only allow New records to be added to the
table with this form. Every time you open this form, it will go to a new
record i.e. you will not see the data you have entered before. Change this
property to No.

 

[John W. Vinson]

I have changed data entry to 'yes' in the property sheet.

That was your mistake.

Data Entry means "this form is used only to input new records, existing
records will not be shown". Set it to No and you'll see all the records in the
form's recordsource.

Do note that the usual way to handle multiple tables with one form is to use a
Form for the "one" side table and one or more Subforms for the "many" tables.