Query of Access getting problem

[dinu79]

Hi
I want to writer a query in access so that it takes one value from the forum and other from the table compare those values and give me other corresponding values from the table
I wrote qurey such as
select table.id
from table where (table.id=detail.textboxvalue)
is it wrong
if u have any suggestion then plz send me the correct form of this query
thanx

 

[oharab]

you're nearly there:

select table.id
from table
where (table.id=Forms!detail.textboxvalue);

should do it.

Ben
----------------------------------
Ben O'Hara
bo104@westyorkshire.police.uk
----------------------------------