This done by referencing the Column property of the combo box in the ControlSource properties of the text boxes as below: ORDER BY Contacts.LastName, Contacts.FirstName īelow the combo box is a set of unbound text boxes which, when a customer is selected, automatically show the customer's address data. ON Countries.CountryID = Regions.CountryID ON Cities.CityID = Contacts.CityID) ON Regions.RegionID = Cities.RegionID) SELECT Contacts.ContactID, LastName & ", " & FirstName AS Customer,Ĭontacts.Address, Cities.City, Regions.Region, Countries.CountryįROM Countries INNER JOIN (Regions INNER JOIN (Cities INNER JOIN Contacts The RowSource property of this combo box is the following In the section on 'entering data via a form/subforms' in this little demo file you'll find a simple orders form in which there is a combo box bound to the CustomerID column in the Orders table.
If you have difficulty opening the link, copy the link (NB, not the link location) and paste it into your browser's address bar. Note that if you are using an earlier version of Access you might find that the colour of some form objects such as buttons shows incorrectly and you will need to amend the form design accordingly. You'll find an example of this inĭatabaseBasics.zip in my public databases folder at: Another way to do this is, rather than joining the tables in a query used as the form's RecordSource, to return the values from the lookup table(s) in a query used as the RowSource of a combo box in the form.
0 kommentar(er)
