Row Source value

[khurram7x]

hi, My SQL query is longer than the maximum limit allowed by the Combo Box Row Source value.
I also cannot use DISTINCT in my query when using as a Row Source for the Combo Box.

Could someone advice how to get around these limits please??

Khurram

 

[bob fitz]

hi, My SQL query is longer than the maximum limit allowed by the Combo Box Row Source value.
I also cannot use DISTINCT in my query when using as a Row Source for the Combo Box.

Could someone advice how to get around these limits please??

Khurram

I've never heard of this problem before so there may be better ways but you could try saving the SQL as a query and then use the query name as the Row Source setting.

 

[jdraw]

I recommend you tell us in plain English, WHAT you are trying to do. There may be options/alternatives, but we need to know WHAT before offering suggestions for HOW.
Good luck.

 

[khurram7x]

...try save the SQL as a query and then use the query name as the Row Source setting.

Thanks Bob, it sorted both my problems. I was under impression that we can not use SELECT against queries.

I recommend you tell us in plain English, WHAT you are trying to do. There may be options/alternatives, but we need to know WHAT before offering suggestions for HOW.
Good luck.

I was looking to run the SELECT DISTINCT query for the RowSource value based on the value selected from another combo box. The size of the query was getting longer because of [forms]![subforms]!... name formatting to the reference column, but the problem is now solved by Bob answer. Thank you.

 

[bob fitz]

Thanks Bob, it sorted both my problems. I was under impression that we can not use SELECT against queries.


I was looking to run the SELECT DISTINCT query for the RowSource value based on the value selected from another combo box. The size of the query was getting longer because of [forms]![subforms]!... name formatting to the reference column, but the problem is now solved by Bob answer. Thank you.

Glad we were able to help.

 

[khurram7x]

Glad we were able to help.

You people are always helpful. Thank you )