Urgent. Subforms not refreshing when I want them to
Posted on 2005-04-25
Using Access 2000.
First I will explain my current form structure. It is very complicated to say the least.
The main form (Frm_MainSample_Entry) contains one large Tab Control with 6 tabs. I am only going to discuss the ones that pertain to my problem.
The three tabs of intrest are |Sample Entry| |Detailed Sample Entry| |Analysis Information|
The Sample Entry tab contains a subform called Frm_DataEntry_MainDataEntry. This is where the intial information is entered (CustomerNumber, Entry Date) . There are several subforms in this subform used for simple sample checkin procedures, but I do not believe they are of importance here.
The Detailed Sample Entry tab contains a subform to deal with samples that require a great deal if information to be entered. Here the sample type is entered (SampleSubID).
This subform is linked to the MainDataEntry subform with the aid of what I call a link box. an unbound text box control called "CustomerLinkB" is placed on the MainSample_Entry Form and is equal to the MainDataEntry Subforms CustomerNumber The subform on the Detailed Sample Entry Tab is linked to this CustomerLinkB control.
There is a subform on this subform listing typical sample types that are specific to the customer number entered on the previous tab. This list is linked to the CustomerNumber of the detailed checkin subform. This is only for Information sake.
On the Analysis Information tab is where I am having my troubles.
I had set this tab up two differet ways to try to fix my problem. I will describe the former, because the latter I know is a problem.
The Analyses tab contains three subforms Frm_DataEntry_SampleTestInfo, Frm_List_Analyses, and Frm_List_CustomerTestDefaults. The first two subforms I am not having any problems with. It is the Third.
This third subform contains yet another tab control with three tabs |Sample Defaults| |Customer Defaults| |All Test Codes|. Each tab control then contains another subform to list each tabs contents. I am having troubles with the first two tabs and subforms here. These two forms contain criteria in their queries that links back to the CustomerNumber and SampleSubID of the previous subforms. I can not get them to automatically update upon the entry of the customernumber and sample Type. All attempts have failed. except one...If I click on the subforms that are not updating and press F9, then they update.
I have tried several refresh, requery, repaint combos, I even tried some F9 sendkey options, but I must not be doing them propperly. I know this is a complicated structure, but I could use any advise. Also I am going live with this DB today, so Time is very important too.
Because of the time importance, I will offer an additional 500 points for this post.