35042

Binding a combobox in subform Access

Question:

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" />

The relationships

<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" />

Recommend

  • How do I fetch the initial Redux state from an API response?
  • reading a csv file from azure blob storage with PySpark
  • MySQL WorkBench - How come the Duration time + Fetch time < real waiting time
  • Spark 2.0: 4 Rows. IllegalArgumentException: bound must be positive
  • Ruby on Rails - Settting up Reviews functionality
  • Tortoise SVN conflict occurs but no edit conflict button is shown
  • Using MPI_Send/Recv to handle chunk of multi-dim array in Fortran 90
  • getting the values of checkboxes in a checkboxlist control
  • using JQuery autocomplete from database with PHP (CodeIgniter)
  • Shrinking Bootstrap Navbar with logo on scroll
  • Yii Bootstrap not loading JS files
  • Getting Microsoft Calibri font on Amazon EC2 ubuntu
  • Windows biometric framework sample umdf driver: This device cannot start. (Code 10)
  • How to make Rss News Reader application in android …? [closed]
  • SQL Server 2012 not showing unicode character in results
  • All Event listing on specified date in Google Calender api (V3) in java?
  • Silverlight Event Log in Isolated Storage
  • How to check if a database and tables exist in sql server in a vb .net project?
  • Multiplying polynomials/simplifying like terms
  • How to define something in JavaScript [closed]
  • Rotating Towards Path in OpenGL
  • Is there a better way for handling SpatialPolygons that cross the antimeridian (date line)?
  • Problems to understand DXGI DirectX 11 Desktop Duplication to get a Buffer or Array
  • C++ STL stack pop operation giving segmentation fault
  • How can I ssh into a server that requires 2 password authentication using python's paramiko mod
  • Amazon Elastick BeanStalk error: Failed to create the AWS Elastic Beanstalk application version
  • How to turn off notice reporting in xampp?
  • Change cell value based on cell color in google spreadsheet
  • Android: Unable to detect vertical plane
  • How to change user identity when git pushing via ssh?
  • VSTS work items list through REST API
  • How to decleare char *const argv[] in swift [duplicate]
  • How to encrypt Connectionstring written in web.config from codebehind?
  • Can someone explain this Java code (formatting the output using System.out.format) to me?
  • Grails - How to implement a foreign key relationship not using an id column?
  • Codeigniniter insert data through models and controller
  • Sign a Pdf using custom digital signature in Java