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

Just thought I'd provide a brief update. At the top of my post I noted that I was using a .adp file. Despite the fact that I still...

I've made a breakthrough / discovery regarding updatable views in a .adp file that I'm compelled to share for the good of the community. Hopefully this will help someone...

My Report

My idea of creating a FK to both tables and constraining the combo box of the Request Type by the selection in the Request Category still has the same...