RE: multiple screens and data capture

Many thanks for this tip.

I just have a few quick follow ups before I give it a try. After that I
probably might need to book a consultation.

1. How do I hide the tabs?
2. How do I code the command buttons to show the next tab?
3. Can I combine this with a switchboard?

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


The first thing that comes to my mind is to use a tab control, placing
various controls on each of the required tabs. Then, if you would like you
can turn off the viewing of the tabs and add command buttons like "Next" and
"Previous", like a wizard that will display each tab in the order you want.
--
HTH

Mr B
askdoctoraccess dot com


"Nick" wrote:

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
.

Loading