We help IT Professionals succeed at work.

Add  a Dropdownlist to a page that update all related fields on a page

cesemj
cesemj asked
on
146 Views
Last Modified: 2013-11-26
Hello,

I would like to create a form that has a Dropdownlist on a page and when the partname is selected all related fields inthe Part table (PartNum, PartName, and PartVendor) associated with the partname selected will automatically be filled in on the form saving data entry time.  Thank you in advance.
Comment
Watch Question

On Dropdown SelectedIndexChanged, type the code to generate the data from the database which you require and bind it to the form.

Do you need an example?

Author

Commented:
Hello,

Yes an example/tutorial.  I understand that I will have the dropdown box, ddbAuotName bound to a field in a table, tblAuotParts - AutoName.  I will have to Enable AutoPostBack the DropDownList box, but when I select the AutoPartName how do I provide an event handler for that to query the access database table, tblAutoParts, so that the fields AutoPartNumber and AutoModelType are automatically field in.

Thank you,
Unlock this solution and get a sample of our free trial.
(No credit card required)
UNLOCK SOLUTION

Author

Commented:
Thank you again, I am going to test it now and will let you know.
Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a sample view!

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.