Cannot view multiple records in Form view

  • Thread starter Thread starter Heather
  • Start date Start date
H

Heather

I am using Access 2000. I have three tables and one
form. I can enter multiple records in the form and use
the record selector to scroll among the new records. But
if I close the form and then reopen the form, all of my
records are gone. I am back to 1 of 1. The information
remains in the tables, but I can no longer see it in form
view. How can I view old records and new records in form
view?

I will be forever grateful if someone can solve this
simple problem.

-Heather
 
1. Open your form in design view.
2. Open the Properties box (View menu).
3. Set the Data Entry property to No (Data tab).
 
Hey Heather - Please post the recordsource of the form.
If it's not the Data Entry property, then probably the
recordsource of the form has some criteria that is
excluding all records. - Anne
 
I used the Form Wizard to create this form. I'm very new
with Access, but I think this is what you're talking about.

SELECT [tblIdentification Data].[Name], [tblIdentification
Data].[Social Security #] AS [tblIdentification
Data_Social Security #], [tblIdentification Data].
[Employee ID], [tblIdentification Data].[Address],
[tblIdentification Data].[Phone Number],
[tblIdentification Data].[Birth Date], [tblIdentification
Data].[Program], [tblIdentification Data].[Program
Status], [tblIdentification Data].[Amount Received],
[tblIdentification Data].[School], [tblIdentification
Data].[Graduation Date], [tblCollection Data].[Reason for
Default], [tblCollection Data].[Default Date],
[tblCollection Data].[Total Amount Due], [tblCollection
Data].[Date of 1st Letter], [tblCollection Data].[Date of
2nd Letter], [tblCollection Data].[Date to Collections],
[tblCollection Data].[Paid Amount], [tblCollection Data].
[Date of Payment], [tblCollection Data].[Type of Payment],
[tblCollection Data].[Date to HR Finance], [tblCollection
Data].[Comments], [tblCollection Data].[Social Security #]
AS [tblCollection Data_Social Security #], [tblSON Default
Interest].[Sent to Tax Dept] FROM ([tblIdentification
Data] INNER JOIN [tblCollection Data] ON
[tblIdentification Data].[Social Security #]=
[tblCollection Data].[Social Security #]) INNER JOIN
[tblSON Default Interest] ON [tblCollection Data].[Social
Security #]=[tblSON Default Interest].[Social Security #];
 
Hi Heather -

Yup, that's what I was talking about. This query has the
words "INNER JOIN" in it. If you were to look at this in
query design view, the "INNER JOIN" would be represented
as a line between the two tables with no arrows on either
end.

In an "INNER JOIN" records are only selected if they
appear in BOTH tables. So in your example, records will
only be pulled if there is a corresponding record in EACH
of your talbes [tblIdentification Data],[tblCollection
Data] and [tblSON Default Interest]. If any of those
tables do not have a record, then the query wont return
anything. So if, for example, there is a record in
tblIdentification Data, but there are no corresponding
records in tblCollection Data, then nothing will be
returned. Does that make sense?

To fix this problem, you need to figure out which table
you want to be the "Master" table. This is the table that
will ALWAYS have inforamtion in it, even if the others are
blank, probably tblIdentification Data from what I can see
here.

Then open the form sql in query design view, by clicking
on the three dot button next to the property. You'll now
see the three tables joined by lines. Double click on the
line and access will open up a dialog box labeled "join
properties". Choose the option that says "Include ALL
records from [your master table] ...".

Repeat that for the other join and you should be all set.

- Anne

-----Original Message-----
I used the Form Wizard to create this form. I'm very new
with Access, but I think this is what you're talking about.

SELECT [tblIdentification Data].[Name], [tblIdentification
Data].[Social Security #] AS [tblIdentification
Data_Social Security #], [tblIdentification Data].
[Employee ID], [tblIdentification Data].[Address],
[tblIdentification Data].[Phone Number],
[tblIdentification Data].[Birth Date], [tblIdentification
Data].[Program], [tblIdentification Data].[Program
Status], [tblIdentification Data].[Amount Received],
[tblIdentification Data].[School], [tblIdentification
Data].[Graduation Date], [tblCollection Data].[Reason for
Default], [tblCollection Data].[Default Date],
[tblCollection Data].[Total Amount Due], [tblCollection
Data].[Date of 1st Letter], [tblCollection Data].[Date of
2nd Letter], [tblCollection Data].[Date to Collections],
[tblCollection Data].[Paid Amount], [tblCollection Data].
[Date of Payment], [tblCollection Data].[Type of Payment],
[tblCollection Data].[Date to HR Finance], [tblCollection
Data].[Comments], [tblCollection Data].[Social Security #]
AS [tblCollection Data_Social Security #], [tblSON Default
Interest].[Sent to Tax Dept] FROM ([tblIdentification
Data] INNER JOIN [tblCollection Data] ON
[tblIdentification Data].[Social Security #]=
[tblCollection Data].[Social Security #]) INNER JOIN
[tblSON Default Interest] ON [tblCollection Data].[Social
Security #]=[tblSON Default Interest].[Social Security #];
-----Original Message-----
Hey Heather - Please post the recordsource of the form.
If it's not the Data Entry property, then probably the
recordsource of the form has some criteria that is
excluding all records. - Anne



.
Click to expand...
.
Click to expand...
 
Back
Top