Wendell;  thanks for your response.  To answer your question; users are using a form.  The errors mostly occur when a user navigates (accidentally tabbing from the last field onto the...

Steve;
Thanks for your response.  I'm not sure I completely understand what you're trying to say... 

only if the dependency is in a straight line, and that something early in the...

Thank you both for your responses.  Perhaps a little bit of back story will help explain what I'm trying to do.

I have an MS Access database (2010) connected...

The other thing to note is a that with the code in the Form_Load() event it doesn't actually get triggered if the form is open!  I'm on the horns of...

Wendell;
Thanks for the this information.  At present, users run the Access front end from their local workstation.  Our method of distributing updates is clunky but it works for us.

We are a government agency regulating energy resource development.  We are "open" (we need to be able to be contacted) 24 hours a day.  The time component of a transaction...

Jeff;

Thanks again for your reply. It will take me a little bit of time to investigate the suggestions that you and Celko (I'm presuming Joe Celko) have made. ...

Hello, and thank you to all of the respondents. I actually didn't think I was going to get anything, it had been a few days. I'm actually on...

You've hit upon the "twist" part. I could be approaching this wrong. I'm assuming a recursion approach because to me this looks like a classic instance of the...

I noticed that my table definition for the [Business_Unit_Flattened] table was not quite right (some columns that should have been nullable were not) so I cleaned it up. Apologies...

I handle this scenario in databases I create by setting a default value of GETDATE() for DateAdded

I use an update trigger to set the value of DateModified.

If...

Thanks for following Wendell.

I will certainly review the references you have provided.

Much has transpired since my post.

I was never successful with a pass-through query since they are not updateable.

For several...

Well, that didn't take long. No joy. The query is still not editable.

The primary key of the main table was included. I have learned that in order for a query to be editable the primary keys of all related tables as...

They are not passthrough queries at the moment. They are based on the linked tables. I did try to create them as passthrough queries but that made the form...