Combo Box

  • Thread starter Thread starter Sharon
  • Start date Start date
No.
What is it you are trying to do? Perhaps we can offer a suggestion.
 
Is there a way to have more than one bound column in a combo box?
Click to expand...

No.
Now if you tell us why you think you need more than one bound column,
perhaps some one can help with an alternative solution.
 
Example:
Table: Employee Table - Field :Employee No Field: Employee Company
When using the pull down in a form the employee No saves as the bound entry,
but I would also like the employee co from that table to save.
 
Example:
Table: Employee Table - Field :Employee No Field: Employee Company
When using the pull down in a form the employee No saves as the bound entry,
but I would also like the employee co from that table to save.
Click to expand...

Why? As long as you have saved the Employee Number field, any time you
need to show the Name associated with the number, you could:

1) Use DLookUp() to find the name.
=DLookUp("[EmployeeName]","EmployeeTable","[EmployeeNumber] = " &
[EmployeeNumber])

or..

2) Setting a relationship between the Employee table EmployeeID and
the main table EmployeeID, in a query, simply drag the Name field onto
the grid..

There is no need to store both fields.
 
You must log in or register to reply here.

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

Combo Boxes - DISPLAYING multiple fields after choice is made 5
Selection from combo box doesn't fill text box 2
filter on combo box possible? 1
Combo Box question. 3
Combo Box Problem 6
my combo boxes 2
Combo Box Values Not Appearing 1
Combo box finding wrong record 4

Back
Top