heyday2004
asked on
Combobox in Access form (using custom query)
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.
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.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.