dlookup as default value

[ShostyFan]

I am not sure what I am doing wrong. This form after updating populates a series of fields from table data and that works fine. But I want the tax rate to be set to the default value of another table titled "Tbl_salesTaxRate". This table has 2 fields, the tax rate data and a checkbox so the user can set what tax rate should be the default.
I have also tried setting the dlookup to the taxRate field's default value property, but that was a no go as well. Any help here would be greatly appreciated.
I should also mention that I made sure that I have a value set to True in the Tbl_salesTaxRate table.

Private Sub Combo31_AfterUpdate()


Me.UnitPrice = Me.Combo31.Column(2)
Me.Taxable = Me.Combo31.Column(3)
Me.Description = Me.Combo31.Column(1)
Me.Category = Me.Combo31.Column(4)

If [Taxable] = True Then
Me.TaxRate = DLookup("SalesTaxRate", "Tbl_SalesTaxRate", "DefaultValue=TRUE")
End If

DoCmd.GoToRecord , , acNewRec
End Sub

[alcapps]

Try
Me.TaxRate = DLookup("SalesTaxRate", "Tbl_SalesTaxRate", "DefaultValue=-1")

Is Defaultvalue the name of the other field?

[pkstormy]

DefaultValue in the expression is referring to a field named DefaultValue in the table, correct?

[alcapps]

Or try
Me.TaxRate = DLookup("SalesTaxRate", "Tbl_SalesTaxRate", "DefaultValue='TRUE'")

[June7]

Is DefaultValue a Yes/No or Text datatype?

Are there many records in Tbl_salesTaxRate that are 'True'? If so, then need more criteria to narrow down the search. DLookup will return value from first record meeting criteria.

[ShostyFan]

Yes, DefaultValue is a field name in the table.

[June7]

More questions in post 5.

[ShostyFan]

I am pleased and embarrassed to say that I figured it out. Turns out my code was correct but my data type was not matching between my form and my table.
The error message never said "miss matched data type", it just returned a compile error, kind of frustrating how much time was spent on this, sorry about that to those who helped.
However, knowing that "DLookup will return value from first record meeting criteria." is something I did not know and will come in very helpful, thanks.