when the list box is changed i want the text box to update

[Princess Kitty]

I'm new to Access. I am using Access 2003. I have a list box and a text box next to it. when a user clicks on the down arrow key and changes the list box i want the text box next to it to make the change also. right now i have this in the Control Source:
=DLookUp("[CPT]","[tblProcedure]","[Procedure]=forms![contacts]![combo186]")

i don't have anything in Onchange event in the list box properties or Afterupdate event in the text box properties.

what do i need to do exactly to get this to work?

thank you in advance!

[ADezii]

I'm new to Access. I am using Access 2003. I have a list box and a text box next to it. when a user clicks on the down arrow key and changes the list box i want the text box next to it to make the change also. right now i have this in the Control Source:
=DLookUp("[CPT]","[tblProcedure]","[Procedure]=forms![contacts]![combo186]")

i don't have anything in Onchange event in the list box properties or Afterupdate event in the text box properties.

what do i need to do exactly to get this to work?

thank you in advance!

'This sample code snippet should help you. The assumptions are: Listbox Name
'is lstTest, the Text Box name is txtLocation, and you wish to populate the
'Text Box with a Location corresponding to the specific ID generated from the
'Combo Box:

Private Sub cboTest_AfterUpdate()
Me![txtLocation] = DLookup("[StorLocName]", "tblStorLoc", "[StorLocID]=" &  Me![cboTest])
End Sub

[NeoPa]

Assuming the ComboBox is populated from tblProcedure too (if not just ignore this post) then another way would be to populate the ComboBox with two columns.
One to display and select on ([Procedure]) and the other to return a value ([CPT]).
That way, when someone selects a [Procedure] the value of the ComboBox is automatically set to [CPT].