Here is what my form looks like.
I want the record on the Proposed lighting subform to have "focus" and come into view, when any field in a record from the first subform is selected. The Main Form is bound to tblProperties and the two subforms' Link Master Fields are both set to txtProperties. Currently, when I use the combo box to select a property, the two subforms correctly show records from the selected property. The problem is that when I go back and forth between Existing Lighting and Proposed lighting subforms, it is very easy to enter data into the wrong field. Ideally, the synchronization would work in both directions, keeping both tables in synch at all times.
Does anyone have any suggestions?
Thank you,
Jonathan