Multi column combo box fill ins

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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
 
Back
Top