Combo box in access project

[MVM]

I am creating a form in an Access project, using SQL Server as the backend.
The project is linked to two tables, Departments and FixedAssets. The form
I am working with is linked to FixedAssets. One of the combo boxes on this
form grabs the drop-down list from Departments, which contains two fields,
Department and Department Number. They select the Department Number for
this particular combo box. What I would like to do is display the
Department in a text box next to the combo box.
I was able to do this in a regular Access database by setting the control
source of the text box
=Combo1.Column(1). When I try the same code in the Access project I keep
getting a #Name? error in the text box. Any ideas?
Thanks for the help!
MVM

[dingusmcgee]

you could use the combo box AfterUpdate event to set the value of the text
box, make sure the text box is unbound.

hth,
dingus
"MVM" <mu********@hotmail.com> wrote in
news:lQ****************@news01.roc.ny:

I am creating a form in an Access project, using SQL Server as the
backend. The project is linked to two tables, Departments and
FixedAssets. The form I am working with is linked to FixedAssets.
One of the combo boxes on this form grabs the drop-down list from
Departments, which contains two fields, Department and Department
Number. They select the Department Number for this particular combo
box. What I would like to do is display the Department in a text box
next to the combo box.
I was able to do this in a regular Access database by setting the
control
source of the text box
=Combo1.Column(1). When I try the same code in the Access project I
keep getting a #Name? error in the text box. Any ideas?
Thanks for the help!
MVM