Multiple Lookups 1

[gk7828]

I have created a work in progress form (WIP) which I enter relevent information for each project. Each project is broken down into job codes, (upto 4 per project) these job codes are in table JobCodes. In WIP I have created 4 Lookup combos which autofill adjacent fields description, named
Jobe Code 1 Description 1 Jobe Code 2 Description 2
Jobe Code 3 Description 3 Jobe Code 4 Description 4
All 4 lookup combo's use the same table (JobCodes).
The lookup combo works in all cases but autofill only works with description 1. When I enter a job code into 2,3,4 lookup does not autofill the associated description.
Is there a reason for this and how can I autofill the descriptions.

 

[TheAceMan1]

Hoe are ya gk7828 . . .

Post the code for one of the combo's in error!

See Ya! . . . . . .

 

[davjr]

SELECT [CCodes].[CCodeID2], [CCodes].[CCode], [CCodes].[Description], [CCodes].[Payment] FROM CCodes;

Private Sub CCodeID2_AfterUpdate()
' Update WIP based on value selected in CCode2ID combo box.
Me!Descript2 = Me![CCodeID].Column(2)

End Sub

Thanks Geoff

 

[TheAceMan1]

Perhaps the missing identifier in yellow below:

[blue]   Me!Descript2 = Me![CCodeID[COLOR=red yellow]?[/color]].Column(2)[/blue]

See Ya! . . . . . .

 

[gk7828]

I have done this and it works only after opening Visual Basic
ie
I select from the lookup combo, no description, I select lookup properties - after update builder to open Visual Basic, close visual Basic then desription displays. I have tried pressing enter, tab key, mouse clicks and anything else I can think of description does not update, only when opening the closing visual basic
very bazaar

Thanks

 

[TheAceMan1]

gk7828 . . .

Check the [blue]Name[/blue] property of the description field. Is it [purple]Descript2[/purple] or [purple]Description 2[/purple]?

See Ya! . . . . . .