Troubleshooting Forms

[Svein Petter]

My advise is that you check the SQL statement. Are all the fields in the
tables needed to create the relationships between them filled with values,
and are the values correct? You may find that some values have to be entered
programatically.

Svein.

 

[Angela Tate]

I just set up a new database and I am having trouble with
my form. The Form is made up of 4 separate tables and when
I enter info into the forms it goes into the tables but
when I open the form again, the information is not there.
Help!!!!

 

[John Vinson]

I just set up a new database and I am having trouble with
my form. The Form is made up of 4 separate tables and when
I enter info into the forms it goes into the tables but
when I open the form again, the information is not there.
Help!!!!

What is the Recordsource property of the Form? Do you have a Form with
Subforms (recommended) or just a massive query? A form cannot be "made
up of 4 separate tables" - a form is just a window onto a Table or a
Query, and most 4-table queries will not be updateable. That's what
Subforms are for.