Form bound control display

[Daryl2106]

Hi,

I'm trying to change the display of a bound control on a form to a linked field in another table. Seems like it should be easy to do; I just can't figure it out.

The bound column is [StudentEnrollment]![AnnualClassNumberID] and is linked to a table called AnnualClassNumbers. The field I want to display is the ClassNumber from the is the AnnualClassNumbers table.

Thanks and take care,



Daryl

[RuralGuy]

You can only bind a control to a field in the RecordSource of the Form. You could display a field from a different table using one of the Domain Functions (DLookup, etc.).

[Daryl2106]

Thanks for the reply. I have attached an image of the query I am working with. The field AnnualClassNumberID from the StudentEnrollmentT is the field that identifies the course a student is enrolled in. The field contains the primary key (ID) from the AnnualClassNumbersT. Is there any way to set the Form field display to ClassNumber (from AnnualClassNumbersT) and yet be able to change it in a form that would also change it (AnnualClasNUmberID) in the StudentEnrollmentT.

OR Is there a better way to do this.

Thanks for having a look.

Take care,

Daryl

[RuralGuy]

You need a ComboBox bound to the AnnualClassNumberID field and a RowSource of the ID and ClassNumber fields of the AnnualClassNumbers table with the ID field display supressed (ColumnWidths= 0";1")

[Daryl2106]

Thank you! Thank You!

That was so efficent and esay to do. I truly appreciate your help.

Take care,

Daryl

[RuralGuy]

You're welcome. Glad we could help.