Thanks for getting back to me. Tried that and it works!
However what I would really like to do is not have to use a pop up box that requires me to enter the registration.
I would like to enter in the registration in the query itself and then beside it the description and type of car would appear. This is because I wish to use the query as the basis of a mileage form which will allow me to enter data.
I have found a clip on you tube that shows the sort of thing I would like to be able to do:
1)User enters the cd number
2)Query displays all the relevant info about the particular cd.
I just don't understand the explanation given in the video and I dont seem to be able to do the same thing in my query.
I have attatched a screenshot of the youtube clip. Also here is the link: http://www.youtube.com/watch?v=o8kmM...eature=related