Forms multiple 'screens' and data capture

[Nick]

Hello

I wonder if anyone can help.

I am trying to design an Access database with a front-end that multiple
users can capture data on whilst talking to customers on the telephone.

The part I am struggling with at the moment is that I have to model this on
a user app that is already in place.

This user app has multiple screens that the users progress through when
capturing different bits of data.

In addition, the app displays some of this data at the end of the process
for the user to write down on a postcard, because for compliance reasons this
cannot be stored electronically.

In total there are 4 screens including the display screen which I would like
to have as a picture of the postcard with the relevant fields populated ...
if that makes any sense?

My question is how can I have multiple screens on an access form that
updates a single table record?

One solution I thought of is to have one form with the controls hidden for
different screens. When the user clicks a command button to get to the next
screen the controls for the current screen are hidden and the controls for
the next screen are unhidden.

Is this possible? Would that be a sensible strategy or if no can anyone
suggest a better way of doing this?

Any help would be most appreciated and I would be willing to donate a
contribution for a complete solution.

Many thanks in advance and best regards

Nick

 

[jaybirdster]

Nick,

I'm not sure if I'm thinking of the same thing when you say 'multiple
screens'. Some of what you say indicates that you have some knowledge
of Access design, and I don't what to appear lofty so take what I say
with a degree of patience and understanding. When you say 'multiple
screens' I think of multiple forms, which can be on the screen at the
same time and can be accessed one after another by hitting 'Alt-Tab'.
A report can be designed to show all four forms as they are, or
customized for easy reading, and I think a command can be designed to
give you a screen shot of all the 'screens' that are in view at the
time. There are other ways to accomplish this as well, so what you
are asking is not at all ridiculous. If you can give me some more
specific information about your current design and your needs, I'll
see if I can help.

Sincerely,

John Byrd

 

[Klatuu]

Use a tab control on your form. Each page can contain the controls that are
on a "screen" in the current application.