| | |
|
|
|
A couple of questions that an expert could help me with |
|---|
| message from David Carter on 12 May 2004 |
Hi,
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.
|
| Larry Daugherty replied to David Carter on 13 May 2004 |
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
|
| Wayne Morgan replied to David Carter on 13 May 2004 |
You do this by using forms for data entry. You can use VBA in the form to
enforce the rules.
|
|
Archived message: A couple of questions that an expert could help me with (MS Access Database)
