bound column and queries

[rob c]

I tried to make several bound columns in one combo box of my form then run a
query based on one of the bound colums I set up. Can someone tell me if what
I set up should work.
===================================================

The code I used to bind the columns is:

Private Sub Atestcolumnchange_AfterUpdate()
Me!ID = cboAtestcolumnchange.Column(1)
Me!cust = cboAtestcolumnchange.Column(2)
End Sub

==============================================
the criteria I used in the form of my query is:

[Forms]![Atestcolumnchange]![cboAtestcolumnchange].[Column(2)]

===============================================

After opening my form and picking a record I try to run the query and get a
popup box that has a space for me to add info and states:

Forms!Atestcolumnchange!cboAtestcolumnchange.Column(2)
===================================================

Form name is: Atestcolumnchange
Combo Box name is: cboAtestcolumnchange
The two columns I used are ID and cust

 

[NTC]

are you trying to have a combobox's selection be the filtering criteria of a
query?

 

[rob c]

Yes, but I would also like to make queries on the information later as well.

are you trying to have a combobox's selection be the filtering criteria of a
query?

I tried to make several bound columns in one combo box of my form then run a
query based on one of the bound colums I set up. Can someone tell me if what
I set up should work.
===================================================

The code I used to bind the columns is:

Private Sub Atestcolumnchange_AfterUpdate()
Me!ID = cboAtestcolumnchange.Column(1)
Me!cust = cboAtestcolumnchange.Column(2)
End Sub

==============================================
the criteria I used in the form of my query is:

[Forms]![Atestcolumnchange]![cboAtestcolumnchange].[Column(2)]

===============================================

After opening my form and picking a record I try to run the query and get a
popup box that has a space for me to add info and states:

Forms!Atestcolumnchange!cboAtestcolumnchange.Column(2)
===================================================

Form name is: Atestcolumnchange
Combo Box name is: cboAtestcolumnchange
The two columns I used are ID and cust

 

[NTC]

a combobox is bound as based on its properties, indicating the column/field
which is being bound.... to use as criteria in the query:

[Forms]![Atestcolumnchange]![cboAtestcolumnchange]


not sure what is meant by 'make queries on the information later
'....perhaps use another query......

Yes, but I would also like to make queries on the information later as well.

are you trying to have a combobox's selection be the filtering criteria of a
query?

I tried to make several bound columns in one combo box of my form then run a
query based on one of the bound colums I set up. Can someone tell me if what
I set up should work.
===================================================

The code I used to bind the columns is:

Private Sub Atestcolumnchange_AfterUpdate()
Me!ID = cboAtestcolumnchange.Column(1)
Me!cust = cboAtestcolumnchange.Column(2)
End Sub

==============================================
the criteria I used in the form of my query is:

[Forms]![Atestcolumnchange]![cboAtestcolumnchange].[Column(2)]

===============================================

After opening my form and picking a record I try to run the query and get a
popup box that has a space for me to add info and states:

Forms!Atestcolumnchange!cboAtestcolumnchange.Column(2)
===================================================

Form name is: Atestcolumnchange
Combo Box name is: cboAtestcolumnchange
The two columns I used are ID and cust