Auto Fill data in textbox from Combobox selection

[Arvin]

Okay ... I think Access hates me ... i tried doing the same thing you ....with another combo box ... and no luck ... it displays the data fine int he cbo but doesn't auto pop the other text boxes .... I made sure that the textboxes are unbound .... and have copied exactly what you did .... wierd ...any suggestions ?

 

[rainman89]

Which combo are you trying to do it from?

 

[MSAccessRookie]

K, .... here is a screenshot of my SQL statement .....

Honestly ...i'm starting to think that "it" hates the email column

Thank you in advance

I would like to see this screen shot in SQL view. I'm bettting it looks something like:

SELECT
....Name,........! <Column0>
....Telephone,..! <Column1>
....Email..........! <Column2>
FROM ASR;

You can use the Above column names in the formula to identify the proper fields for your formula