Query for use in combobox

I used the following instructions from a web page online.


     To filter records in a combo/listbox based on the value selected
in another combo/listbox,  you can use a stored query which uses the
first control's value as a parameter. For example,

Select PeopleID, PeopleName from tblPeople Where PeopleID = Forms!
FormName!NameOfFirstControl;

Then all you need to do is issue a Requery on the second combo/listbox
in this first control's AfterUpdate event.

Private Sub NameOfFirstControl_AfterUpdate()
    Me!NameOfSecondControl.Requery
End Sub


However, when I try to enter the parameter (Location Name and Location
Code from Location ID Where Vehicle ID = Forms!Location ID and
Component ID Generator!Vehicle ID) in the query, it gives me the error
message, "Invalid bracketing of name"...  what am I doing wrong?

I'm really stuck here, so any help would be GREATLY appreciated.
Thanks