>I have a combo box that is linking improperly or so it seems. I have done this a thousand times but this one just won't link properly..
>
>Row source is Lookupdata.description
>Row source type is Alias
>
>Controlsource is master.id
>
>interactive change updates master.id with lookupdata.id.
>
>Report links fine but form shows different description.
>
>I have both tables in the data environment of the form and link master.id to lookupdata.id
>
>This is driving me and my users crazy. I have other combo's on this page that works fine.
>
>What could I be missing?
If you're using Alias as RowSourceType, it should be just 'LookupData'
Otherwise use 6 - fields
'LookupData.Description, ID'
Adjust ColumnWidths to not show ID field. ColumnWidths would be something like '200,0'
If it's not broken, fix it until it is.
My Blog