Form and Combo-Boxes

[Kevin Field]

Hi, not sure wether this the right place to post this but here goes.

I have one table which has two columns, Adviser Code and Adviser. Each code is an abbreviated version of the full advisers name.

I currently have a form which has two combo boxes. The first combo box looks up the table and only displays the adviser code. The second looks up the same table and shows the name.

I am trying to get the second combo box to synch with the first so when you select an adviser code the other box automatically shows the full name.

They have to be seperate as i use them for lookups in queries and reports.

Is this possible?!

Help!

 

[Trevor G]

Kevin welcome to the forum,

A suggestion is, on the form if both sources are from the same then use an After Update Event to use the column number, something like this, you will have to change the combo box names and also check how many columns you are using, in the case below I have 3 columns (AutoNumber, Advisor and AdvisorCode, the column count in the brackets is actual the 3rd column as when counting this way it starts from 0.

Private Sub cboAdvisor_AfterUpdate()
Me.cboAdvisorCode.Value = Me.cboAdvisor.Column(2)
End Sub

 

[mighty3]

You will have to use JavaScript in order to accomplish what you want with your two combo boxes.

 

[Trevor G]

You will have to use JavaScript in order to accomplish what you want with your two combo boxes.

Mighty3 welcome to the forum,

I would ask why you think this needs Java as Kevin isn't giving any indication that he is trying to use a form on a website?

Access Form with Visual Basic for Application seems to be the solution as I indicated in my reply to Kevin

 

[dfenton]

Java and JavaScript have virtually nothing to do with each other, other than the first 4 letters of the name.

And, of course, they have nothing at all to do with programming in Access.

 

[Kevin Field]

Thank you to all the above who have helped me, especially Trevor. This is now working an i appreciate the assistance!