Solved It shows that there is invalid use

[hucheunghugo]

X = DLookup("PlayID", "Houses", NameCond = 1 And DateCond = 1 And TimeCond = 1)

There is no null value in my table.......

 

[hucheunghugo]

Will it be affected if the PlayID is auto number?

 

[hucheunghugo]

X = DLookup("PlayID", "Houses", "NameCond = 1" And "DateCond = 1" And "TimeCond = 1")
And if i use this, there will be a type missmatch

 

[bob fitz]

What is the "Data Type" of NameCond,DateCond and TimeCond

 

[hucheunghugo]

What is the "Data Type" of NameCond,DateCond and TimeCond

They are all number

 

[Gasman]

Put " around the criteria in your first post.
Google the syntax as well.

 

[bob fitz]

Have you tried:
X = DLookup("PlayID", "Houses", "NameCond = 1 And DateCond = 1 And TimeCond = 1")

Edit:
I believe that's what Gasman is suggesting in his last post, which I've only just noticed

 

[hucheunghugo]

Have you tried:
X = DLookup("PlayID", "Houses", "NameCond = 1 And DateCond = 1 And TimeCond = 1")

Edit:
I believe that's what Gasman is suggesting in his last post, which I've only just noticed

This fixed my problem thank a lot!!