Limiting Data Entry in MS Access?

Question

How do you limit a data in MS Access? Let's say that a certain entry can only have a maximum of 3 dependent entries. For Example: A person may only have three accounts. How do I tell MS Access to prevent that person from having a fourth account?

Really, really need help on this one...I'm not that adept at VB or Macros

Answer 1

It's not much of an answer, but I don't think there is an "Easy way".  

In order to do this You'll have to have a VBA function built into the Data Entry form that counts the # of dependent entries, and turns off the ability to add data.  Depending on Your skill level there are numerous ways to do that.

If You already HAVE a Macro or VBA function that Adds the dependent entries You'll need to re-code it to check the number of existing entries first.

Not knowing the structure of your Tables or Forms I really can't give even sample code that You could "tweak".  It may be best to take this question to a Forum where back & forth discussions and even screenshots can be used to see what You have done & What needs to be done to finish it...