display column values based on primary key selection in combobox

[SoxPats83]

i have a table where i have a couple hundred records bound to a form. i have added a combobox to this form to show all of the calues in the primary ID in a dropdown. what i want is to have the user select the primary ID from the dropdown and then a bunch of text boxes on the form (each text box represents the other fields) will populate with the values on that primary ID's record?

thoughts?

 

[boblarson]

My sample here does just that. The key is including extra info in your combo's row source so you can reference the appropriate column.

 

[SoxPats83]

My sample here does just that. The key is including extra info in your combo's row source so you can reference the appropriate column.

this example worked like a charm form me when i opened it in Access2003. i am now trying it out in Access2007 and the "Method" or "Data Member" (?) of Column doesn't seem to exist in VBA. very odd...

 

[boblarson]

Did you remember to put it in a trusted location?