Simple sql query problem

Hi I have this query in ms access which is somehow not working. All I need to do is to pull out donator name from donator table with the id of volunteer. But I need to get user input, volunteer name and pull out the related volunteer first. Please help.

SELECT volunteer.id, volunteer.name, donator.* FROM volu开发者_如何学Pythonnteer, donator WHERE Volunteer.id = Donator.vid AND Volunteer.name = Forms!frm5!Combo2;

---

Check your case on Database names. For instance, you reference volunteer.name and Volunteer.id. In some DB's, fields are case sensitive.

Also, you'd want to quote your volunteer name field.