Buttons that open new forms

[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.

 

[Kate Cz via AccessMonster.com]

Hi Krefty,

I would use command buttons that run macros to open separate forms for the
additional data to do this. I'm not sure how adept you are at access but....
If you create a new macro, there is an "OpenForm" option from the dropdown
list. Then you can run a macro off of a command button in form design view
(select "miscellaneous" from the command button wizard to run a macro). I
would create several of these command buttons running macros that are
attached to forms that include the additional data users may or may not have
to enter depending on the situation. In this case the database would require
6 (your example) tables for 6 forms.

Perhaps there could be text (using labels from the toolbox) on the form
asking users if such cases exist in which they would have to enter additional
data, at which time they would click the command button that would take them
to the additional forms.

There are quite a few nice database examples at microsoft office's website:
http://office.microsoft.com/en-us/templates/CT011359381033.aspx

Hope this is of some help~

Kate Cz