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
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