Viewing more than 1 record in form

G

Guest

Hello
I have a subform for entering employee time data.

It has the following fields:

Project Number Hours Work Code Description


So for each project number entered a new record is created in the form,
however I want all the records displayed one after another on the form
instead of having to scroll over using the arrow keys. So basically as soon
as i enter a project number another row should pop up that will allow for
another project number to be entered so it looks like this:

Project Number Hours Work Code Description
605 2 3 Reporting
607 6 2 Mapping
604 1 2 Management

I tried making it a continous form but that doesn't seem to have worked.

Please help.

thanks in advance.
 
J

John W. Vinson

Project Number Hours Work Code Description
605 2 3 Reporting
607 6 2 Mapping
604 1 2 Management

I tried making it a continous form but that doesn't seem to have worked.

You may need to rearrange the controls on the form. Open your Continuous Form
in design view. Use the View option to view the Form Header; cut and paste the
labels for your fields into the header. Snug all the textboxes (or other
controls) up to the very top of the detail section, neatly under their
corresponding labels; then snug the bottom of the detail section up under the
textboxes.

When you display the form, you should see a datasheet-like grid with each
project on one row.

I suspect what's happening now is that you have a big (tall) detail section;
you're seeing multiple records but they're bigger than the screen space for
them.

John W. Vinson [MVP]
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top