Is it possable to when using the Square brackets ( [ Enter Name Here ] )to search a query, you know so they can enter there own choice, to limit there option to whats held with in a dropdown box, that is held with in that collyum is also limited to a dropdown box. i just don't want them to come to me complaining that they can not find something because the spell the code wrong?
there is no drop down. ok ill simplfiy this a bit. i have a collum what is limit to only have 4 value: book in, Quoted, ordered and booked out. so that is the only thing that the collum will except.
Now i want to query this with to critera one being name and the second being where the item is booked in, quoted etc. so what do i do so that when teh little window pops up, it ask for the name and then give a drop down box listing: book in, Quoted, ordered and booked out?
I would change this. Based on your other answers you need to get rid of all these look ups and set up proper relationships between tables.
The short answer is you cannot do exactly what you want but you can pretty well do the same. Set up a form, stick on a combo looking up those four values, have the query reference the combo (as in my first post) and have a button to run the query.