records in table don't match records in form?

R

RYANneedsHELP

in my tblpersonnel i have 5 records, but in my form it only shows 1 (the one
I created using the form), shouldn't the form show the records from the tbl
as well?
 
S

scott04

When you layout your form did you select Justified? If so that would be the
reason the form is only bringing up one record at a time. If the layout was
tabular or datasheet it would look more similar to the design of your table.
 
J

John W. Vinson

in my tblpersonnel i have 5 records, but in my form it only shows 1 (the one
I created using the form), shouldn't the form show the records from the tbl
as well?
Click to expand...

Maybe, maybe not! Several questions:

- Is the Form's Recordsource the table itself, or a query based on that table?
It might be a query which displays only one record.
- Does the Form have its filter set? Look at the funnel icon on the toolbar:
if it's selected (dark) click it to unfilter.
- Possibly vexing question but I don't know your level of Access knowledge...
if it's a form in Single view, it SHOULD show only one record, and have a
navigation box at the lower left with "previous" and "next" and an indication
such as "record 1 of 5".
- Possibly you have the Form's "Data Entry" property set to True. If so it
will show only the most recently entered record, and no previous ones.
 
T

Tom van Stiphout

On Wed, 17 Sep 2008 05:54:01 -0700, RYANneedsHELP

You changed something to filter the records. Check this:
* The Filter property of the Form
* The way the form is opened with DoCmd.OpenForm
* What the form is bound to. Perhaps a query with a Where clause.

-Tom.
Microsoft Access MVP
 
Top