PDA

View Full Version : Solved: use combobox to populate the form



gsanghvi20
07-29-2008, 07:27 AM
Hey 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

OBP
07-29-2008, 09:02 AM
gsanghvi20, assuming that your Form is based on a Table with the data in it already you create your Combo using the Combo Wizard, but you do not Choose the default type of Combo you choose the
"Find a record on my form based on the value I selected in my Combo".
This will find any record that has your Primary Key.

gsanghvi20
07-29-2008, 09:33 AM
thanks a zillion, it worked:clap: