2 Column Combo Boxes in display.

[ThebigCt]

I have it set up so in the combo box drop down that it shows both columns that I want displayed but when an option is chosen, only the first column shows up in the box. I need both to show up.. I searched the forms and found a few things but I still wasnt able to complete it. Any tips?

[June7]

A combobox will show only one column. If you want more than one field to show in the box, construct a column that concatenates fields into one string. Like:

SELECT ID, ID & " | " & fieldname As somename FROM tablename;

[ThebigCt]

Thanks June7. Where would enter this equation?

SELECT ID, ID & " | " & fieldname As somename FROM tablename;

[June7]

Use the example I gave as the RowSource for combobox. Use your field and table names in place of the generic aliases. In place of 'somename' use whatever you want.

Concatenation is really useful for situations like:

SELECT ID, LastName & ", " & FirstName As EmpName FROM tblEmployees;
SELECT ID, Address & ", " & City & ", " & State & " " & Zip As CustAdd FROM tblLocations;

Review tutorials at http://datapigtechnologies.com/AccessMain.htm especially the 3 on comboboxes in the Access Forms: Control Basics section. I don't think they show the concatenation technique but should find other stuff of interest.

[ThebigCt]

SELECT Position_Name & " | " & Organization_Name As Internship_1_Name FROM Student;

Does this look correct, if I'm trying to get my combo box display to look like :

Event Manager | Entertainment Inc

If event manager is the position name and Entertainment Inc is the organization name?

If that is correct where do I enter the equation?

Thanks.

[June7]

Not quite. I expect you need the unique ID field included as shown in the examples.

The SQL SELECT statement goes in the RowSource property of the combobox. Then set other properties:

ColumnCount: 2
BoundColumn: 2
ControlSource: ID (only if this is a bound control and use whatever your unique ID fieldname is)
ColumnWidths: 0";2"

[ThebigCt]

That website is very helpful. I'm going to attach my database so you can see where I am talking about.
On the form: Student
On the combo box: Field Experience
This combo box is a conditional box using a query as a row source for the Semester and the year. so I am a bit confused on how I should tackle this one.

[June7]

No attachment to your post.

[ThebigCt]

SPTM Internship Database1.zip

Here is the file

[June7]

RowSource for FieldExperience combobox is to restrict list to positions that are field category and available during the year selected in another combobox? Since should be saving the pk Practicum_ID, not PositionName, need to include Practicum_ID in the RowSource. Same goes for the other Experience fields. Means the comboboxes must be multi-column. One of the tutorials I referenced previously shows that. Alternative is the Position_Name field is made the pk. So fix tables and relationships or fix comboboxes.

[ThebigCt]

I got it figured out. Thank you.