By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,701 Members | 1,970 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,701 IT Pros & Developers. It's quick & easy.

Combo box in access project

P: n/a
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
Nov 12 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
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


Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.