Multiple Columns in Forms.ComboBox.1

C

Can

I am working on setting up an N-Tier application and I am using the
Microsoft Access Developer's Guide to SQL Server by Mary Chipman and Andy
Baron. I am following their N-Tier example in Chapter 14.

To search for a record instead of using the typical multi-column combo box,
I am using an ActiveX control
OLE Class: Microsoft Forms 2.0
Class: Forms.ComboBox.1

I have it working but there is a change I would like to make. Right now the
boundcolumn is the autonumber because that is the field it needs to search
on. Since people want to search by name I want to set it up so that it is
(1) bound to the name but have a hidden field that after they select a
person their autonumber is copied to that hidden field
(2) keep it bound to the autonumber but have a display field right beside it
so when they select the person's autonumber their name is displayed.

Either way it requires me to access the value of a column other than the
bound one. With a typical combo box it's just
HiddenField = ComboBox.Column(3) (to reference the 4th column)

What is the syntax to do this with the Forms.ComboBox.1?

Thanks in advance
 

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

Top