I have a subform which has the correct Source Object, Link Master field and Link Child field parameters.
I can create a combobox in the subform which shows the correct information in the drop down menu (same table as the source object of the subform), but is <strong>unbound</strong> and does not update the record in the main form.
Does anyone know how this might be fixed?
(note the relationship between Master and Child is over multiple tables, but has referential integrity and cascade updates enabled)Answer1:
The fact that the combo is on a subform is not relevant in this case. The wizard will set everything for you, but the rule for binding a control is to set the
Control Source. For example, your subform contains a list of places by PlaceID and you wish to update it using a combo that shows the user a list of place names in a combo.
Control Source: PlaceID Row Source : SELECT ID, PlaceName FROM Places ORDER BY PlaceName Bound Column : 1 Column Count : 2 Column Widths : 0; 2cm
<img alt="A combo on a subform" class="b-lazy" data-src="https://i.stack.imgur.com/Lu0Qz.png" data-original="https://i.stack.imgur.com/Lu0Qz.png" src="https://etrip.eimg.top/images/2019/05/07/timg.gif" />
<img alt="relationships for the tables" class="b-lazy" data-src="https://i.stack.imgur.com/I73Ul.jpg" data-original="https://i.stack.imgur.com/I73Ul.jpg" src="https://etrip.eimg.top/images/2019/05/07/timg.gif" />