ComboBox

[Daryl2106]

Hi,

This is a problem I keep coming back to. How do you write the SQL to show the the associated field in the ComboBox Field and the "list" while storing the Key field. I tried the query builder and came up with the following. Everything is okay except the list is 100+ records long instead of the 16 it is supposed to be.

Thanks and take care,

Daryl

SELECT ContactInformation.FacultyAdvisor, [LU_Instructor]![LastName] & ", " & [LU_Instructor]![FirstName] AS FacultyName FROM ContactInformation INNER JOIN LU_Instructor ON ContactInformation.FacultyAdvisor = LU_Instructor.InstructorID;

[June7]

Sounds like this is what you want http://datapigtechnologies.com/flash...combobox3.html

It's not just the query that needs to be structured right, but the combobox properties.

RowSource: SELECT InstructorID, LastName & ", " & FirstName AS FacultyName FROM LU_Instructor;
ControlSource: FacultyAdvisor
BoundColumn: 1
ColumnCount: 2
ColumnWidths: 0";2"

[Daryl2106]

Hi June,

Thanks again. I did figure it out, but now I have the reply and link to rememebr how to do it next time

One other question I am trying to resolve. I have a subform that will not accept new records. When I choose the selection to add a new record to existing records, all fields populate, but it doesn't get saved. Another issue I am sure I resolved before, but right know I am at a loss.

Thanks and take care,

Daryl

[Daryl2106]

Hi Again,

I think I figured it out. I think is was the parent child fields that were absent. It seems to be working now. Does this make sense?

Daryl

[June7]

I guess if it does what you want, then it makes sense. I can't know any different without knowing more about db.

[Daryl2106]

Thanks June,

Your replies are always helpful and greatly appreciated.

Take care,

Daryl