Missing Records in Form View

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Can someone help? I have data in 18 records, however, when I am inputting in the form view it misses out anything that holds data in a particular field! Therefore in form view it says there are 14 records, when there are definitely 18. Have pinpointed the particular field that it doesn't like data in, but can't seem to find the problem with it

Any ideas anyone!
 
Does your form's recordsource have a WHERE clause that would cause some of
the data to be filtered out?

--
Rob

FMS Professional Solutions Group
http://www.fmsinc.com/consulting

Software Tools for .NET, SQL Server, Visual Basic & Access
http://www.fmsinc.com

-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Rachel said:
Can someone help? I have data in 18 records, however, when I am inputting
Click to expand...
in the form view it misses out anything that holds data in a particular
field! Therefore in form view it says there are 14 records, when there are
definitely 18. Have pinpointed the particular field that it doesn't like
data in, but can't seem to find the problem with it!
 
If the RecordSource of your Form is a Table, check the Filter Property and
FilterOn Property of the Form.

If the RecordSource of your Form is a Query combining 2 or more Tables,
especially with Inner Join or Where clause, check the Query by itself (i.e.
not through the Form) and see how many rows are returned.

If only 14 rows, then the problem is in the Query. If 18 rows are returned,
then check the Filter & FilterOn Properties of the Form.

--
HTH
Van T. Dinh
MVP (Access)




Rachel said:
Can someone help? I have data in 18 records, however, when I am inputting
Click to expand...
in the form view it misses out anything that holds data in a particular
field! Therefore in form view it says there are 14 records, when there are
definitely 18. Have pinpointed the particular field that it doesn't like
data in, but can't seem to find the problem with it!
 
OK ... Multi tables means Query/SQL String in term of Form's RecordSource.

Open your Form in DesignView. Open the Properties window of the Form. In
the "Data" tab, the first Property is the RecordSource which should contain
the SQL String (or the saved Query name).

Click on this row and click the "Build" button with 3 dots on the right and
a Query grid will appear with the SQL String already parsed. You can run
this Query and most likely, it will only returns 14 rows.

This is the Query you need to modify.
 
OK - Now we are getting somewhere! Sorry - didn't know you could do that - am self-taught on this program, so learning all the time

Am in the query! Displaying 14 instead of 18, how do I make it stop!!!!
 
Rachel said:
OK - Now we are getting somewhere! Sorry - didn't know you could do
Click to expand...
that - am self-taught on this program, so learning all the time!
Am in the query! Displaying 14 instead of 18, how do I make it stop!!!!
Click to expand...

The standard join between tables in a query will filter out records that do
not exist in both tables involved in the join. My guess is one of your
tables does not have matches on two of the records so they are filtered
out. If you double-click on the join lines you are provided two other
alternatives for the join type.
 
Back
Top