combo box trouble!!!

[suganya]

Hi All,
i am totally new to ms access and need your help.i have two combo
boxes in my form.Each value in the combo box has one or more related
records.What i want to do is choose one value from the combobox1 and
the list in combobox2 gets trimmed.Then i choose a value from
combobox2 and a specific record gets selected and i view it in all the
textboxes.i tried changing the controlsource property of textbox but
that doesn't seem to work well.'#Name?' keeps displaying in it.i would
appreciate any help.

thanks in advance.
suganya.

 

[Thomas]

Hello I am new to Access myself but I think
I know what your looking for try this in the ControlSource of the TextBox

=([YourComboxName].[Column](1))

YourComboBoxName = the name of your ComboBox

If that don't work use this

=[YourComboBoxName]

YourComboBoxName = the name of your ComboBox

BTW
What you have is a Cascading ComboBox.
To get answers from the big hitters in this news group
you need to post the code your working with so
they can give you a intelligent answers.