?
Solved

Combobox in Access form (using custom query)

Posted on 2009-05-12
1
Medium Priority
?
309 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 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 does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Question has a verified solution.

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

If you need a simple but flexible process for maintaining an audit trail of who created, edited, or deleted data from a table, or multiple tables, and you can do all of your work from within a form, this simple Audit Log will work for you.
Windows Explorer lets you open cabinet (cab) files like any other folder. In VBA you can easily handle normal files and folders, but opening and indeed creating cabinet files takes a lot more - and that's you'll find here.
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…
Have you created a query with information for a calendar? ... and then, abra-cadabra, the calendar is done?! I am going to show you how to make that happen. Visualize your data!  ... really see it To use the code to create a calendar from a q…

621 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