Drop-down box not populating from data source

J

joeman

I have a SQL database with a bunch of code tables.

I have a field on my form - a dropdown box - that is bound to "JobTitle"
field in my main data source.

In the SQL database, this field is keyed to a code table to field "TitleID."
The code table also has "TitleName" which is a description of the job title.

I have a secondary data source set up to retrieve data.

I have bound the Dropdown box to "JobTitle" in the main data source, and the
list box entries to the code table (value=@TitleID and display=@TitleName).

When I display the preview form, nothing is populated in the dropdown box at
all. The SQL field definitions are the same (INT,4).

What am I doing wrong?
 
J

joeman

Thank you, Sandeep, but neither of those links really applies to the issue
I'm having. One is dealing with an XML data source (which I'm not using),
and the other deals with a situation where the drop-down is already
populating correctly.

Any other ideas?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Help creating a search form in Access XP 0
Link a text box based on drop down box with four options MS Word 365 0
Add additional information to excel form after original data entry 0
How to use/create code in MS Word to calculate age? 0
Task Information Dialog Box not making duration changes to task 0
Dynamic Naming of Form Button 3
Consolidation Table from Different Excel Tabs with Different Format 1
Creating a Search using a combo box and then creating a report. 4

Top