Dlookup problem

[Ray Maker]

Hello,
I have the folling statement in a query field:
Type: DLookUp("[Signal type]","signal","[SignalID] =" & [signalID])

By it'self it works fine, and looks up the data perfectly. However if I add
this:
Like "*" & [Please enter Wire Identifier:] & "*"

to the criteria field to let the user search throught the field, it doesn't
let me, and give me the error message:
Syntax error (missing operator) in query expression '[SignalID] ='.

What does this mean? And how can I fix it? All of this stuff relies upon
the table called "wiremain", while the signalID in the table is a combobox
with the "signal type" and "signalID" from the table signal. Basically I
want to be able to search thought the signal type that are in the wiremain
table.

Thanks.

Sincerely,
Ray Maker
WireBook Technologies
Ra...@wirebooktech.com

[Eric Sabine]

I am not sure what are your tables or forms based on your question.
If I understand correctly (based on your dlookup)
Wiremain is a table, unless it's a form and signal is a table. I'll just
assume wiremain is the table.
Signal Type and SignalID are fields in your table.

Use a query to perform your search.
par example

SELECT [Signal Type] FROM wiremain WHERE SignalID LIKE *' & [Please enter
Wire Identifier:] & '*';

I usually avoid dlookup

Eric
Ray Maker <funsk...@email.msn.com> wrote in message
news:uGcYltZJ$GA.52@cpmsnbbsa03...

[acropora]

The only time I use DLookup is to read a systemparameter

Eric Sabine wrote in message
<6TMT3.1664$vc6....@typhoon.southeast.rr.com>...

[Hahamov Gil]

Try
DLookUp("[Signal type]","signal","[SignalID] Is Like "*" & [Please enter
Wire Identifier:] & "*")

Ray Maker wrote in message ...

[Joe "Nuke Me Xemu" Foster]

Ray Maker <funsk...@email.msn.com> wrote in message news:uGcYltZJ$GA.52@cpmsnbbsa03...

> Hello,

> I have the folling statement in a query field:
> Type: DLookUp("[Signal type]","signal","[SignalID] =" & [signalID])

> By it'self it works fine, and looks up the data perfectly. However if I add
> this:
> Like "*" & [Please enter Wire Identifier:] & "*"

Embedded text values and search patterns need to be quoted:

DLookUp("[Signal type]","signal","[SignalID] like '*000*'")

DLookUp("[Signal type]","signal","[SignalID] like '*" & [signalID] & "*'")

--
Joe Foster <mailto:jfo...@ricochet.net> Space Cooties! <http://www.xenu.net/>
WARNING: I cannot be held responsible for the above They're coming to
because my cats have apparently learned to type. take me away, ha ha!