Complicated Validation

[elcinolmez]

Well maybe not complicated for Access experts but it is very much for me
I am creating a database for several bank accounts. In this dbase there are monies coming in and going out. also there are money transfers between bank accounts. my problem is with this transfers between bank accounts. I have columns: "Action, "FromBank" and "ToBank". And "Action" Field is limited to: outgoing, incoming and intratransfer. What I dream is this;
"ToBank" will take value only if "Action" is "intratranster" and the value can only come from a certain list. If "Action" field is something else, say "outgoing", than "ToBank" will not take any value.
how can I do that?

[June7]

With, as you said, complicated code in various events. Actually, the code is particularly difficult, but figuring out all the events to use is the tricky part.

You might want to set the FromBank and ToBank fields as not Enabled and only make them available as data is entered and only for the appropriate data. Use comboboxes - review http://datapigtechnologies.com/flash...combobox2.html