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...

Wendell;

Thanks so much for the link above. It's a good description/discussion of the issue. It certainly confirms my experience and discoveries. Unfortunately the link to the video,...

One last post. Now that I have determined the true source of the problem I have found a possible resolution.

Read here;

http://www.experts-exchange.com/Software/Microsoft_Applications/Q_27813872.html

I've discovered the cause of the SubForm requery behavior, specifically the Current event of the SubForm being called.

First, a recap. I was experiencing an odd behavior on a SubForm...

Wendell;

The main form is bound. The reason for the text boxes is to enable the grid portion of the split form to display properly.

The reason for the split form...

I'm sorry for the longwinded response. I wouldn't blame you if you don't read it...

I've attached a screenshot which will help with understanding what I'm dealing with.

There's a main form...

Minor update;

I've discovered that the Current event of the Subform is actually triggered before the MouseMove event, so, it's not related to the MouseMove event per-ce.

This is truly bizarre behavior....

I'm so glad to finally have some knowledge to contribute back to the forum!

The answer to this problem is that the key press, in this case a tab key (or...

I've also tried the DoCmd.GoToControl ("Regulatory_Sector_DB_Key")

The behavior is the same... 🙁

I have come to the same conclusion that you have regarding the OnCurrent event. I am using a bound form. I have found a workaround though that was...

I'm sorry I forgot to include this information. I'm using MS Access 2010. The file format is an .accdb. I'm using linked tables to a SQL Server...

I have a similar need. I need to know, when a user is moving from one record to the next, which control has focus. I've tried using Screen.Activecontrol...

Thanks for the response Wendell.

The answer to your first question is; I'd like to... I think. Right now I have separate Access file for DEV, TEST, and PROD environments....