Multi column combo box fill ins

L

Lorraine

I have MS Access 2000 and I am trying to fill in multi fields in a form (5
fields will always be the same) using a combo box where I selected these five
items, but I can not figure out how, when selecting the first column, it will
fill in the other five fields too. I am not great with VB, but have been
trying Macros, but no luck. Can anyone answer this question.
 
S

Steve Schapel

Lorraine,

You mean you have a combobox with 5 columns, and you want the values
from the other 4 columns to be shown on the form? Well, make the
Control Source of the other textboxes like this...
=[NameOfYourCombobox].[Column](1)
=[NameOfYourCombobox].[Column](2)
.... etc
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Link a text box based on drop down box with four options MS Word 365 0
MS365 WORD: How to Create Macro Button to CLEAR ALL fields in fill-in form 1
Combo box 0
Creating Labels Over 3-Up Image 2
Filling controls based on a value in a combo box 2
Finding the right style field in VBA 0
How to fill a combo box with choice from another combo box 7
Combo Box that fills Text Box in form 4

Top