Subforms link to Master

J

John

I have a database that tracks test results for patients.

I have a form with about 8 tabs leading to different pages.

Page 1 is the Patient Info page with name, SSN, birthdate,
etc.

Each subsequent page is a test result. Because the tests
have so much info in them, each test is based on a
separate table. I display the test results on each page
using a subform that is linked to the table for that test.

Here's the issue: The main page lets you use the scroll
wheel to scroll through ALL records. This is good to have
for this page.

When I go to page 2 to see the first test, the scroll
wheel only cycles between the current record and the
default blank record. However, the other subform pages
will scroll through ALL records again. I have compared
the various subforms on each page and I can find NO
DIFFERENCE that would explain this. I am obviously
missing something.

I would actually like to have the main page scroll through
ALL records but to have the other pages NOT scroll and
remain on the active record. This would prevent me from
accidentally changing patients while reviewing a test
result.

Thanks for any help on this.

John
 

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