Expiring Today—Celebrate National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

Combobox in Access form (using custom query)

Posted on 2009-05-12
1
Medium Priority
?
303 Views
Last Modified: 2012-06-27
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.
0
Comment
Question by:heyday2004
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
1 Comment
 
LVL 6

Accepted Solution

by:
BALMUKUND KESHAV earned 2000 total points
ID: 24361981
do the following
open a new form in design view
drag a combo box from toolbox -
combo box wizard will apper
click on next--> select query -->pick your query here
select fields here which you want to populate in your combo box( at least 2, one which will show and another which will reference like any id)
click on next----> next---> finish

that's it.


bm keshav

0

Featured Post

What Is Blockchain Technology?

Blockchain is a technology that underpins the success of Bitcoin and other digital currencies, but it has uses far beyond finance. Learn how blockchain works and why it is proving disruptive to other areas of IT.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In Part II of this series, I will discuss how to identify all open instances of Excel and enumerate the workbooks, spreadsheets, and named ranges within each of those instances.
This article shows how to get a list of available printers for display in a drop-down list, and then to use the selected printer to print an Access report or a Word document filled with Access data, using different syntax as needed for working with …
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…
In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.

730 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question