Linking information from one field to another

[lstone1]

Hi,
I created a database of which I have several individuals use. Currently, I
have a form that includes the following fields "Loss$"; "Branch$"; "Advisor
$"; another Dept$. I also have check boxes for Branch; Advisor; Dept.
Right now team members add an $ amount in the Loss field and then if Branch
is checked, they have to add the $ amount in the Branch$ and sometimes this
Loss$ amount can be split between Branch and Advisor or Advisor and Dept, etc.
Is there a formula or module I can create to automatically take the amount
from Loss$ and add to the other fields.

For example:

Loss$ = $100
Branch is checked
Branch$ = automatically updated as $100

or

Loss$ = $100
Branch is checked
Dept is checked
Branch$ = automatically updated as $50 (we should be able to override
manually)
Dept$ = automatically updated as $50 (we should be able to override manually)


Please let me know.

Thanks

Linda

 

[Guest]

You are doing double entry. If you have a field for $'s there is not need
for a check box to indicate dollars for the same field.

 

[Larry Daugherty]

What you are discussing are "business rules". In every case you can
do what you want to do. But, the best place(s) to do the various
things are highly related to how you have designed your data and what
you have for a user interface already. Things like that are best
designed well in advance of actually putting your application
together. Maybe next time....

Usually, the point of action will be in command buttons or other event
code in other controls on forms.

HTH

 

[lstone1 via AccessMonster.com]

Hi Karl,

No, I actually I am not doing double entry the check boxes are used in order
for my team to indicate in advance who we would be charging losses to. They
are their own entity and have their own purpose.

Yes, I realize my database is already in place but I am in the process of
improving it offside of what my team uses and I hope to make it more
effective. I actually created the database when I had absolutely no
knowledge of access whatsoever. I have made numerous revisions and
improvements since.

Any further advise to complete my request would be appreciated.

Thanks
Linda

You are doing double entry. If you have a field for $'s there is not need
for a check box to indicate dollars for the same field.

Hi,
I created a database of which I have several individuals use. Currently, I

[quoted text clipped - 26 lines]

Linda

 

[lstone1 via AccessMonster.com]

Hi Larry,

You are correct, the point of action would be in event procedures but I would
appreciate an example of how to do this so that I can proceed. I realize the
database is built and is in use; however, I am currently in the process of
rebuilding it offside of what the team uses. I have already completed many
changes since I built it as I built the database with no knowledge of access
whatsoever.

Thanks,
Linda

What you are discussing are "business rules". In every case you can
do what you want to do. But, the best place(s) to do the various
things are highly related to how you have designed your data and what
you have for a user interface already. Things like that are best
designed well in advance of actually putting your application
together. Maybe next time....

Usually, the point of action will be in command buttons or other event
code in other controls on forms.

HTH

Hi,
I created a database of which I have several individuals use. Currently, I

[quoted text clipped - 26 lines]

Linda

 

[Larry Daugherty]

Hi Linda,

You didn't respond to my response to you: The burden is on you to
explain, in detail and in the context of your problem area, just what
is happening now and exactly what you would like to have happen.

My communication budget on this one is expended.

--
-Larry-
--

Hi Larry,

You are correct, the point of action would be in event procedures but I would
appreciate an example of how to do this so that I can proceed. I realize the
database is built and is in use; however, I am currently in the process of
rebuilding it offside of what the team uses. I have already completed many
changes since I built it as I built the database with no knowledge of access
whatsoever.

Thanks,
Linda

What you are discussing are "business rules". In every case you can
do what you want to do. But, the best place(s) to do the various
things are highly related to how you have designed your data and what
you have for a user interface already. Things like that are best
designed well in advance of actually putting your application
together. Maybe next time....

Usually, the point of action will be in command buttons or other event
code in other controls on forms.

HTH

Hi,
I created a database of which I have several individuals use.

Currently, I
[quoted text clipped - 26 lines]

Linda

 

[lstone1 via AccessMonster.com]

Hi Larry,

I think I have it all figured out. Thanks

Hi Linda,

You didn't respond to my response to you: The burden is on you to
explain, in detail and in the context of your problem area, just what
is happening now and exactly what you would like to have happen.

My communication budget on this one is expended.

Hi Larry,

[quoted text clipped - 24 lines]