Solved

Problem setting up a combo box to find a record on my form.

Posted on 2015-02-23
4
141 Views
Last Modified: 2015-02-25
Usually when I add a Combo Box to the a form the wizard asks "How do you want your combo box to get its values?". Then I can choose
  "I want the combo box to get the values from another table or query."
  "I will type in the values that I want."
  "find a record on my form, based on the value selected in my combo box."

Now today I add a combo box to a form and only get two options.

"I want the combo box to get the values from another table or query."
"I will type in the values that I want."

But I want "find a record on my form, based on the value selected in my combo box."

Can anybody explain why on this form, which is based on a query, I do not get the required option?
0
Comment
Question by:Fritz Paul
  • 2
4 Comments
 
LVL 47

Expert Comment

by:Dale Fye (Access MVP)
ID: 40625773
The "find a record on my form" is in the next part of the wizard, not in the section asking where you want to get your values from.
0
 
LVL 34

Accepted Solution

by:
PatHartman earned 500 total points
ID: 40625875
The form needs to be bound for this option to appear.
0
 

Author Closing Comment

by:Fritz Paul
ID: 40627951
I still don't understand, but I made it work based on your tip.
The data source was a table which I sorted where I defined the source. It only gave the two options.
Then I made the data source just the table and arranged the sorting in the form definition. Then it worked.
So in both cases it was bound as I understand it.
Regards,
0
 
LVL 34

Expert Comment

by:PatHartman
ID: 40631493
If the FORM doesn't have a table or query as it's RecordSource, then the combo only gives you the two options.  How can it find a record on a form that isn't bound?  So adding the RecordSource to the form is what makes the third option available.

The combo itself is bound to the RowSource which is what produces the list of choices to pick from.  It may also be bound to a field if the ControlSource shows a column from the Form's RecordSource.  When the combo is bound to a field, It will display or update the field as necessary.
0

Featured Post

Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
data analyst 3 48
MS Access Tables Linking 6 40
MS Access 03, TransferText, decimal places 8 37
Export Query data to excel file 14 26
It took me quite some time to sort out all the different properties of combo and list boxes available from Visual Basic at run-time. Not that the documentation is lacking: the help pages are quite thorough and well written. The problem was rather wh…
In a multiple monitor setup, if you don't want to use AutoCenter to position your popup forms, you have a problem: where will they appear?  Sometimes you may have an additional problem: where the devil did they go?  If you last had a popup form open…
Using Microsoft Access, learn some simple rules for how to construct tables in a relational database. Split up all multi-value fields into single values: Split up fields that belong to other things into separate tables: Make sure that all record…
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…

932 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

18 Experts available now in Live!

Get 1:1 Help Now