Macro???

[Krefty]

I am looking for details maybe even a database example...of the following. I
can create a database and feel I am a moderate level user for all my
interaction for the past 4-5 years with databases that I have created.

I have not created this yet but I have started to play with the idea and
can't seem to solve this issue. I dont know if this should all end up in one
table or 6 seperate tables?

I have employees that create a document for every incoming call and on one
form that I created in word it includes questions that allways need completed
and then there are all the questions that need to be asked for 1 of 5 events.
If seems to confuse them and they end up answering questions that do not
apply.

My idea is that I create a form with fields that get answered on every
client. Then within that form I desire creating 5 buttons below the required
fields that if selected it would open or unlock a new set of required data to
be completed.

If this hits anyone please email and ask or please email and advise. I can
really work well with examples.

 

[Kathy Webster]

Let's say you want an additional set of questions answered if the caller's
favorite color is blue.
The additional questions are in the form called frm_Blue.

Your starting form is frm_CallerQuestions.
The field where you store the caller's favorite color is called
[FavoriteColor].
In the AfterUpdate property of the [FavoriteColor] field, type the name of
your macro:
m_Blue

Display the conditions column in the macro builder. Type this in the
condition column:
[FavoriteColor]="Blue"

In the action column, select "OpenForm", then type the name of the form you
wish to open in the argument: frm_Blue

Kathy Webster