Solved Filter Combobox based on textbox valeu (1 Viewer)

[mafhobb]

Hi.

This is probably really simple but I am struggling.

I have a combobox on a form that has the following RowSource:

SELECT [qryCleaningCostPerProperty].[PropertyName], [qryCleaningCostPerProperty].[CleaningType], [qryCleaningCostPerProperty].[CleaningCost] FROM [qryCleaningCostPerProperty];

This combobox shows all the data for all the properties ("PropertyName" field)

In this same form, I have a textbox (txtPropertyName) which is filtered on load to a specific property.

How do I filter the combobox so it only shows the records for that property?

mafhobb

 

[arnelgp]

maybe add code to the Current event of the form:

private sub Form_Current()
With me!combo
.RowSource = "SELECT [qryCleaningCostPerProperty].[PropertyName], [qryCleaningCostPerProperty].[CleaningType], [qryCleaningCostPerProperty].[CleaningCost] FROM [qryCleaningCostPerProperty] Where [PropertyName] = '" & Me![txtPropertyName] & '

 

[mafhobb]

Got it.
Many thanks!
Mafhobb