A couple of questions that an expert could help me with

D

David Carter

Hi,
I'm stuck for an assignment I have to do at Uni, could
someone please help:

How do I enforce business rules in a table to
automatically link 2 attributes in a table
i.e. - if a change is made to an attribute in a table to
a value between null/not null how to I get the other
attribute to change to another predefined value in a
value list.
 
W

Wayne Morgan

You do this by using forms for data entry. You can use VBA in the form to
enforce the rules.
 
L

Larry Daugherty

You can't do that from an Access table. You shouldn't be doing data entry
directly into a table but use a form instead. On a form you can do what you
are trying to do by putting the appropriate code in the AfterUupdate event
of the relevant text boxes.

HTH
 
Top