MOVING BETWEEN FORMS

[Michel Mondor]

Hello and thanks for reading this.

I have an Access database that I have designed at work to
control my flow of workorders. I use it to register
incoming trouble calls and to open, follow-up and do the
final invoicing on my workorders. All the data in
condensed in one single database which is about 200 fields
wide. I am using several different forms throughout the
process of receiving calls to invoicing my customers.
But, I have one problem and here it is: I now have a
total of well over 500 workorders entered in this
database. When I open a workorder, I use a worksheet on
my PC screen in which I enter all the required info which
will appear on the Workorder. But, when I transfer from
this worksheet to the actual workorder (using a macro in
Access) I cannot move from, let's say register # 213 in
this worksheet, to workorder # 213 but end up at register
# 1. Is there a way to move from one index in one form
to the same index in a different form ?

 

[John Nurick]

Hi Michael,

This is very easy. Open your form in Design view. Make sure the Control
Wizards ("magic wand") button on the toolbox is turned on.

Then draw a commandbutton on the form. When the wizard starts up, select
"Form Operations", "Open Form" and specify that you want to find a
particular record. Follow the remaining instructions in the wizard, and
there you are.

Sooner or later, however, you may find that the structure of your
database - a single table of 200 fields - causes you problems. FOr
instance, any time your workflow changes you'll have to revise the whole
thing. It might be worth learning a bit about relational database design
and normalization with a view to restructuring your data for the long
term.