refer to column in query builder 2

[Pampers]

Hi everyone,
Can one refer to a column of combox in your query criterium field, like:

[Forms]![frmCompanyCost]![frmCompanyCostSub1].[Form]![CompanyCostTypeID]![column(1)]

I don't get an error message, but go no results either.

Pampers
Keeping it simple can be complicated

 

[mhartman1]

Hello:

[YourComboName].[Column](1)
Will give the item in column 1 of a combo box. So in your statement, maybe ....

[Forms]![frmCompanyCost]![frmCompanyCostSub1].[Form]![CompanyCostTypeID]![YourComboName].[Column](1)

Regards
Mark

 

[Pampers]

Tnx Mark,
I will give it a try tomorrow at work. Keep you posted.


Pampers
Keeping it simple can be complicated

 

[dhookom]

You can only refer to the bound column with that type of expression. The solution that I use is to create a text box on the form with a control source like:
=[CompanyCostTypeID]![column(1)
You can then use the text box in your query criteria. You can also use the Eval() function with the column reference.


Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]

 

[Pampers]

Hi DHookom,
Thanx for the info. That clears things up.

Well, that is what I did too (first solution) - create a textbox that refers to the column and refer that textbox in the query. Works ok.

Pampers
Keeping it simple can be complicated