Macro???

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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
 
Back
Top