Condition Based Data Entry

Is it possible to automatically generate a form?

Hi,

i have the following problem.

I'm developing a database in Access for financial analysis of companies. First a user enters the balance sheet and Profit and loss account. Then calculations are made to find whether balance sheet and P/L account entries need explanations. For example:

Fixed assets 100
Cash 50

I have two formulas:
If fixed assets are more than 90 then the user should explain what do they contain. If cash is more that 60 then the user must explain why. In this case explanation is required only for fixed assets.

I guess that i should make a table that contains explanations, now i want access to generate an input form that asks questions about only needed explanations (in the example fixed assets) while assignin 0 to all the cells that do not need explanations. Is this possible?

Gatis

Hi,

could anyone just say whether it is possible or not and maybe give some pointers on how to do it, i will then learn to do it myself!

Gatis

It's hard to visualise this - do you have an example on a form?

Example

Mile-O-Phile said:

It's hard to visualise this - do you have an example on a form?

Click to expand...

I will create an example databes and post it here later in the evening!

Gatis