Auto Fill data in textbox from Combobox selection

[Arvin]

Hello,

I'm totally nesw at this ... so any help would be appreciated

Basically I have a table that stores all the info I need auto pop.

Table (Employess) > Employee Name, Phone, Email

On the form ... I would like to achieve ...

When you select the employee name, that the Phone and Email textboxes auto pop ...

Now, this is the current code I'm using and it only auto pops the Phone textbox and not the Email textbox...

Private Sub Originator_s_Name_AfterUpdate()
Me.[Originator_s_Telephone] = Me.[Originator_s_Name].Column(1)
Me.[Originator_s_Email] = Me.[Originator_s_Name].Column(2)
End Sub

I get no errors either .... I'm stumped

thank you in advance

 

[rainman89]

is your column number correct? remember it starts at 0

 

[Arvin]

Okay ...when you say column ... do you mean the one in the "employee" table or the query table ?

 

[rainman89]

I mean column in your combo box

 

[Arvin]

Sorry ...so new at this ... Column count states "1" and bound Column is set to "0"

 

[rainman89]

column count is 0? what i mean is, if you have a value in your combo box like so

ID | person name | phone | email |
column(0) column(1) column(2) column(3)

 

[Arvin]

Yes you are right ....but when I went into the properties of the cbo it states the column as 1 and when i change it ... it telling me that it must be set between 1 and 255

 

[rainman89]

can you post up a sample?

 

[Arvin]

Here you sir .... I hope this is what you want .....

 

[Arvin]

and ... here are screenshots of the table and query ....

 

[rainman89]

if you change it to this

Private Sub Originator_s_Name_AfterUpdate()
Me.[Originator_s_Telephone] = Me.[Originator_s_Name].Column(1)
Me.[Originator_s_Email] = Me.[Originator_s_Name].Column(3)
End Sub

 

[Arvin]

Just did ... and no luck .....same as before .....it only auto pops the Phone textbox and not the Email textbox

 

[Arvin]

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

 

[rainman89]

can you post a sample of your database?

 

[Arvin]

Here you go sir .....

 

[rainman89]

no no. The actual database itself.
Remove all sensitive data from it, compact and repair it then zip file it and post it up here so i can take a look

 

[Arvin]

Will do ... in 2 mins ...thank you so much!

 

[Arvin]

As requested .... here you go

 

[rainman89]

Here you go. Dont have the text boxes bound, since you are assigning them with the query. Hope this helps!

 

[Arvin]

OMG! ...bless you man ! ...wow Thank you Thank you Thank you! ! !