Dlookup in form

[GregTheSquarePeg]

Hi,



I'm a bit of an Access novice (to say the least), but keen to learn as much as possible.

I'm creating a very simple form, where a user enters a value, the value is then looked up in a large table and a 'SuppNo' is returned.

=DLookUp("SuppNo","dataCatExtract","[ISBN] = " & [Forms]![ISBNSearch]![ISBN])

I put the above into the ControlSource field of a form text box. The 'ISBN' does exist in the table, and does have a corresponding 'SuppNo' - yet the above returns an error (#Error)

Any help would be greatly appreciated.

Gregg

[GregTheSquarePeg]

Cracked it:

=DLookUp("[SuppNo]","dataCatExtract","[ISBN] =" & "[Forms]![ISBNSearch]![ISBN]")