Combobox in Access form (using custom query)
Posted on 2009-05-12
I'm new to Access, below is for sure an easy question:
In an access application, I create a query:
SELECT DISTINCTROW tblA.Selected, tblA.NUMBER, tblA.STATUS, tblA.Office From tblA
and use this query, I created a form (or datasheet):
Some database fields are combo box, like Office, Status, they are bound with a dropdown list of data.
Some database fields are textbox.
How is the combo box created by Access and where is the binding list from? Thanks a lot.