A couple of questions that an expert could help me with

  • Thread starter Thread starter David Carter
  • Start date Start date
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.
 
You do this by using forms for data entry. You can use VBA in the form to
enforce the rules.
 
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
 
Back
Top