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.