Solved

Combobox in Access form (using custom query)

Posted on 2009-05-12
1
297 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
1 Comment
 
LVL 6

Accepted Solution

by:
BALMUKUND KESHAV earned 500 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

Live: Real-Time Solutions, Start Here

Receive instant 1:1 support from technology experts, using our real-time conversation and whiteboard interface. Your first 5 minutes are always free.

Question has a verified solution.

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

Introduction The Visual Basic for Applications (VBA) language is at the heart of every application that you write. It is your key to taking Access beyond the world of wizards into a world where anything is possible. This article introduces you to…
Overview: This article:       (a) explains one principle method to cross-reference invoice items in Quickbooks®       (b) explores the reasons one might need to cross-reference invoice items       (c) provides a sample process for creating a M…
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
What’s inside an Access Desktop Database. Will look at the basic interface, Navigation Pane (Database Container), Tables, Queries, Forms, Report, Macro’s, and VBA code.

816 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

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now