VBA DLookup to an excel range (1 Viewer)

[flaghippo]

Hi All
I am having problems with Dlookup from a table which is linked to Excel.
The heading on the fields from Excel have been imported as
F1, F2, F3 etc... the code I am using is as follows .....

LOOK = DLookup("F6", "DATABASE_LOOKUP", "F1 = 1338087")

F6 = A date I am looking up.
DATABASE_LOOKUP = table I am looking up.
F1 = 1338087 = The record I am looking for.

Error is Run-time 3464.
Data type mismatch in criteria expression.

Thanks

 

[vbaInet]

F1 is probably reading as Text:

"F1 = [B][COLOR="Red"]'[/COLOR][/B]1338087[COLOR="red"][B]'[/B][/COLOR]"

 

[pr2-eugin]

Also what have you declared LOOK as? If it is anything other than variant, possibility is that you are trying to assign a Null to a String/Number type.

 

[flaghippo]

Hi all and thanks for your responce.
It is working now but only finds the first record !
Any further help would be great.
Thanks

 

[pr2-eugin]

It is working now but only finds the first record !

That is what DLookup does, do you wish to see more? You might need to create a Query or use Recordset object.

 

[vbaInet]

Or even use a subform.