CODEWITHSUNDEEP
vbams-access
sambob_628
sambob_628

Reputation: 133

Access - Filtering Continuous Form Text Field From A ComboBox

I'm trying to filter a Continuous Form by the [Resource Categories] field which is a text box using a combobox [ComboResourceCatV2] And then a second filter to check the operation is still open [OpCmplt]

Me.Filter = [Resource Categories] = " & ([ComboResourceCatV2]) & " And ([OpCmplt] = False)
Me.FilterOn = True

I don't understand as i have used this approach before without issue but this time it keeps returning a blank form...

Any suggestions what maybe causing it?

Upvotes: 0

Views: 887

Answers (1)

Kostas K.
Kostas K.

Reputation: 8518

Ty this:

Me.Filter = "[Resource Categories] = '" & [ComboResourceCatV2].Value & "' And [OpCmplt] = False"

Your quotation marks were a bit off.

Upvotes: 1

Related Questions