Records don't increment

  • Thread starter Thread starter Paul Breslin
  • Start date Start date
P

Paul Breslin

Hello --

Windows XP Home edition
Access 2000

I have a form which can pull its records from a query or a table.
I know the query is running correctly because it shows every record in the
correct sort order and so forth..

I have a number of fields but they include 'employee number', 'employee
name', etc. Yet, on my form, the form only displays the first record of the
record set on every line and doesn't increment to the next record.

I made about a dozen lines of text boxes and in every 'employee number' the
same number is display, (the first record of the set), and in 'employee
name' the same first name in the record set is displayed.

There must be something I just click to let the program know I want it to
increment the values on the form.

Any ideas?

Thanks,
Paul
 
Well, a little confusion here. Most forms have a specific data source, and
not sure what you mean by "incrementing". If your form is designed as a
"single form", then only one record will be displayed at a time. Use the
record selectors ( or PgDn/PgUp) to move to other records. A "continuous
form" will show in its detail section as many records that fit, and those
can be scrolled up/down.

Post back if I haven't understood what you wanted.
-Ed
 
Paul Breslin said:
Hello --

Windows XP Home edition
Access 2000

I have a form which can pull its records from a query or a table.
I know the query is running correctly because it shows every record in the
correct sort order and so forth..

I have a number of fields but they include 'employee number', 'employee name',
etc. Yet, on my form, the form only displays the first record of the record
set on every line and doesn't increment to the next record.

I made about a dozen lines of text boxes and in every 'employee number' the
same number is display, (the first record of the set), and in 'employee name'
the same first name in the record set is displayed.

There must be something I just click to let the program know I want it to
increment the values on the form.
Click to expand...

Making multiple copies of your controls is NOT how you get Access to display
multiple records. You create ONE set of controls bound to your fields. Then if
you open the form in single view you see one record at a time and use the
navigation buttons to navigate. If you want to see multiple records at once and
scroll up and down then you open the form in continuous view or datasheet view.
 
Back
Top