Troubleshooting Forms

  • Thread starter Thread starter Svein Petter
  • Start date Start date
S

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.
 
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!!!!
 
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!!!!
Click to expand...

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.
 
Back
Top