Access combo box question

[Oromia]

Hi, I have a combo box question.

Using a code I am assing a value to my combo box like this me.mycombo = prefixData

mycombo is bound to a query qryActivity.

In most cases prefixData is a prefix of a value in qryActivity, it is not the entire field.

What I am trying to accomplish is see a list of records that start with prefixData in the qryActivity (which is attached to a combobox) when prefixData is assigned to my.mycombo or when I click the arrow of the combo box.

Thanks.

 

[Remou]

You would be better, I think, to set the RowSource of the combobox according to the prefix:

[tt]Me.cboCombo.RowSource = "SELECT ID, Blah FROM qryActivity WHERE Blah Like '" & prefixData & "*'"[/tt]

 

[Oromia]

I might be doing some thing wrong but it didn't work for me. The following is what I did.

Me.activity_area.RowSource = "SELECT [activity area] from qryActivityAreaLookup where [activity arera] like '" & tempActivityArea & "*'"


[activity area] is the field in the query (qryActivityAreaLookup)
qryActivityAreaLookup is the query attached to my combo box
tempActivityArea is the prefix.
activity_area is the combo box.

Thanks

 

[Remou]

Is that a cut-and-paste? If so, the second [activity arera] is mis-spelt; if not, in what way is it not working?

 

[randy700]

This may or may not be causing a problem....
Change like '" & tempActivityArea & "*'"
to like '" & tempActivityArea & "'*"


Randy

 

[Remou]

randy700

Are you quite sure? I have always used:

Like 'Blah*'

Not

Like 'Blah'*

 

[Oromia]

Thank you Remou and Randy700, that part is working but it messed up the rest of the query since I don't always populate the field that way. I have worked around that issue now. Thanks for your help.