Fill Multiple Fields From One Combo Box - Microsoft Access Forum


	Back to Access Forum Comments List

Upload Images @Reply Bookmark Link Email Next Unseen

Fill Multiple Fields From One Combo Box

Shane Carruth

15 months ago

I want to see if it is possible to retrieve information from one table that has a combo box in a form and that fill other fields with associated information. Example, I select Grainger from the combo box and it fills in the address, number and email that are associated with them.

	Kevin Robertson @Reply 15 months ago
DLookup AfterUpdate & DLookup

	David Torrey de Frescheville @Reply 15 months ago
Kevin is right. Lookup and AfterUpdate. If you are new to this like me, I was very confused with the parameters, but I watched some of Richards older videos on it and it really helped. Here's a link: https://youtu.be/ZmcGlywA4ss?si=mG0HqRVLIR8M3Lvm. Also see Kevins links above on these.

	John Davy @Reply 15 months ago
Hi Shane, For example: ProductName = ProductCombo.Column(1) Description = ProductCombo.Column(2) Just determine which column your field is in. HTH John

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Access Forum.

Next Unseen

New Feature: Comment Live View