Type mismatch

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

hughess7 - 18 Jan 2006 12:01 GMT

Hi all

I am trying to use the dlookup function and get a type mismatch error. Can
anyone tell me why. The fields in the tables are either double or text
(bracket). Code is:

Dim txtBracket As String
Dim intFuelAmt As Double
Dim intVAT As Double

txtBracket = Me![cboVehicle].Column(3)
intFuelAmt = Me![FuelCost]
intVAT = DLookup("[Amount]", "tblFuel", "FuelCost = " & intFuelAmt
And "Bracket = " & txtBracket)

Thanks in advance for any help.
Sue

Reply to this Message

Alex Dybenko - 18 Jan 2006 12:10 GMT

hi,
text should be in quotes, and you have to be aware of null, so try:

intVAT = nz(DLookup("[Amount]", "tblFuel", "FuelCost = " & intFuelAmt & "
And Bracket = '" & txtBracket"'"),0)

Signature

Alex Dybenko (MVP)
http://alexdyb.blogspot.com
http://www.PointLtd.com

> Hi all
>
[quoted text clipped - 13 lines]
> Thanks in advance for any help.
> Sue

Reply to this Message

hughess7 - 18 Jan 2006 14:48 GMT

Great thanks Alex that sorted it (although you had a missing & before the "'"
after txtbracket.

Cheers
Sue

> hi,
> text should be in quotes, and you have to be aware of null, so try:
[quoted text clipped - 19 lines]
> > Thanks in advance for any help.
> > Sue

Reply to this Message