How to view three consecutive records on one form simultaneously

[Mark M Simonian]

I am using Access 97 on a Windows 2000 PC.

How can I force only three consecutive records onto a form so I can see them
simultaneously? Subforms?

I am trying to place only three physician records on a form without using a
datasheet view so I can get about 5 fields packed into a smaller space and
not be forced to scroll horizontally. Name Address City Phone & Cross
Street.

I use a query to select a physician that meets three criteria set by a
telephone caller and rank the physicians by the oldest date logged for the
screener- finding the physician who was called less recently than the other
physicians.

I can view this nicely in a report but I thought that I must push this onto
a form simultaneously so a screener can read the information back to the
caller and more significantly use a setvalue Macro to paste this into a
reference table to repeat the process without the call screener typing the
new filtered information for the next caller - simplifying the information
logging and process for the next caller. The reason is that once a physician
is selected a timestamp will be used as a reference for the next ranking and
caller query.

It is the form with three simultaneous records I can't figure out. I am
required to move to the next record to see the selection. Suggestions?
-----------------------------------------------------
Mark M Simonian MD
5305 N Fresno St #105A
Fresno, CA 93710
(559) 221-7192
(e-mail address removed)
www.markmsimonian.medem.com
****************************************
Alert: This email and any files transmitted with it
are intended solely for the use of the individual or
entity to whom they are addressed and may contain
confidential, patient health or other legally
privileged information. If you have received this
email in error please notify the sender by email,
delete and destroy this message and its attachments.
Any unauthorized review, use, disclosure,
or distribution is prohibited.

 

[Steve Schapel]

Mark,

You should be able to do this effectively with a form in continuous
view. If your query only returns the 3 records you need, no sweat.
If the query could return more than 3 records, size the form so its
height will accommodate 3 records, and set the form's Scroll Bars
property to Neither.

- Steve Schapel, Microsoft Access MVP

 

[Mark M Simonian]

Thank you. I think I was having a problem doing that because I used a Tabbed
form and it said no continuous form, right?

--
-----------------------------------------------------
Mark M Simonian MD
5305 N Fresno St #105A
Fresno, CA 93710
(559) 221-7192
(e-mail address removed)
www.markmsimonian.medem.com
****************************************
Alert: This email and any files transmitted with it
are intended solely for the use of the individual or
entity to whom they are addressed and may contain
confidential, patient health or other legally
privileged information. If you have received this
email in error please notify the sender by email,
delete and destroy this message and its attachments.
Any unauthorized review, use, disclosure,
or distribution is prohibited.

 

[Steve Schapel]

Mark,

If you mean you want to put a Tab Control on the form, so it shows for
each record, then I think you are correct... you can't do this with a
continuous form. If you mean you want your form that shows the 3
records to be on a Tab of a Tab control (i.e. it is a subform), then
AFAIK there is no problem with doing this.

- Steve Schapel, Microsoft Access MVP