Relative Content

Tag Archive for formssubform

Unable to Update/Filter One Access Subform from another

I have a main form (frm_Update_Fleet_Data) with two embedded subforms (subfrm_Fleet_Data and subfrm_Ship_Details). subfrm_Fleet_Data contains the partial results of qry_Current_Fleet in a continuous form listing of ships in the fleet. Selecting any record in subfrm_Fleet_Data provides all the record data for the selected ship. That part of the form works perfectly. Where I’m having trouble is using a modal form (frm_Filters) to allow the user to create an ad hoc query. The user selects or enters field values which are then used to create a FILTER string (‘strFilter’). I’m having difficulty passing the FILTER string to subfrm_Fleet_Details.Filter property.