use combobox to populate the form

[gsanghvi20]

Hi guys,
I am new at VBA programming. Please help!
I have a form with text boxes and one combo box which has the Primary key values as a drop down list. Now, on the basis of the selection in the combo box I want to populate the values in the text boxes. Please let me know how am I supposed to do this.
Thanks,
gsanghvi20

 

[namliam]

Have a search for "Cascading Combobox" in the reference forum, you will find some samples.

 

[gsanghvi20]

I searched on "Cascading Combobox" but only came up with results which link 2 comboboxes together. But I want the table to be linked to the form(text boxes) and when I select a particular PK from the combo box, that particular record is displayed (using different text boxes) which can also be updated, if wanted to.

 

[georgedwilkinson]

Are you saying you want to filter your form or go to a record on your form based on the value you select in the combo-box?

 

[gsanghvi20]

Thanks guys, I figured it out.

 

[georgedwilkinson]

Alright! Way to go.