reference current input field

[Guest]

hello

i need to create a query in access 2000 that uses the current records fields
to generate a drop down list that only contains data that is relevent rather
than the whole list for every input i can program this externally but is
there a way to do this with access?

thanks

 

[tina]

set criteria on the field you want to filter for relevancy, as

WHERE MyTable.MyField = "Some value"

hth