Hello,

I developed a database using Access 2003. I then tried to deploy my access database to several users who do not have Access. I installed Access Runtime (from Visual Studio Tools) onto their computers.

However, there is a drop down that is populated by a dynamic query...(has Forms!FormName!Control in the criteria). This drop down works on my computer but does not work on any computer running access runtime. Has anyone else had any issuses like this?

Thought I might try to clarify the problem a bit more...


Problem:
I have a form with a sub-form. Member_Facility, and Member_Facility Component. On the Main the form the user select a value from a dropdown called "Deal Dropdown". The afterupdate triggers a requery on a field in the subForm. The values shown in the AbleID drop down are then based on what was selected in the Deal Dropdown.

The user then selects from the ABLE ID dropdown on the subForm. The afterUpdate then triggers another requery on another dropdown in the subForm called "ComponentID". Component ID rowsource should then be based on ABLE ID. The functionality is very similar, and it works on my computer (I developed it and I have retail access). When I package and deploy this application on another machine the second requery will not work.

Query that does not work:


SELECT ACBS_MCT_DW_ABLE_COMPONENT_IDS.ABLE_COMPONENT_ID, ACBS_MCT_DW_ABLE_COMPONENT_IDS.ABLE_ID, ACBS_MCT_DW_ABLE_COMPONENT_IDS.DUNS
FROM ACBS_MCT_DW_ABLE_COMPONENT_IDS LEFT JOIN ACBS_MCT_MEMBER_FACILITY_COMPONENT ON ACBS_MCT_DW_ABLE_COMPONENT_IDS.ABLE_ID = ACBS_MCT_MEMBER_FACILITY_COMPONENT.ABLE_ID
GROUP BY ACBS_MCT_DW_ABLE_COMPONENT_IDS.ABLE_COMPONENT_ID, ACBS_MCT_DW_ABLE_COMPONENT_IDS.ABLE_ID, ACBS_MCT_DW_ABLE_COMPONENT_IDS.DUNS
HAVING (((ACBS_MCT_DW_ABLE_COMPONENT_IDS.ABLE_ID)=[Forms]![Member_Facility]![Member_Fac
ility_Component]![ableid]));

Code to Trigger broken Query that populates dropdown:

Private Sub ableid_AfterUpdate()

Forms!Member_Facility!MEMBER_FACILITY_COMPONENT.componentid.Requery

End Sub


Query that Works:

SELECT ACBS_MCT_CLIENT_DEAL.DEAL_INFORMATION_ID, ACBS_MCT_CLIENT_DEAL.ABLE_ID, ACBS_MCT_DW_ABLE_COMPONENT_IDS.DUNS
FROM ACBS_MCT_DW_ABLE_COMPONENT_IDS INNER JOIN ACBS_MCT_CLIENT_DEAL ON ACBS_MCT_DW_ABLE_COMPONENT_IDS.ABLE_ID = ACBS_MCT_CLIENT_DEAL.ABLE_ID
GROUP BY ACBS_MCT_CLIENT_DEAL.DEAL_INFORMATION_ID, ACBS_MCT_CLIENT_DEAL.ABLE_ID, ACBS_MCT_DW_ABLE_COMPONENT_IDS.DUNS
HAVING (((ACBS_MCT_CLIENT_DEAL.DEAL_INFORMATION_ID)=[Forms]![Member_Facility]![DEAL]));


Code to Trigger working Query that populates dropdown:

Private Sub DEAL_DROPDOWN_AfterUpdate()

Forms!Member_Facility!MEMBER_FACILITY_COMPONENT!ableid.Requery

End Sub