How do i make my access query work in vb and access?

[Spawny]

Hi, I have a query in access that i amd trying to run in VB5 but have a problem. My problem is: The query I have written needs a parameter or something. The code I have entered is a sql query:

SELECT * FROM Clients WHERE Clients.AccountID = Results.AccountID
ORDER BY Surname;

It comes up with a question mark on Results.AccountID but the relationship is one is to many (1 from Clients.AccountID)
Now what I want the query to do is where Clients.AccountID = primary key in Clients table and Results.AccountID = Foriegn Key in Results table, I want it to equal the same value so that when i run a different query these 2 fields are exactly the same. Is there some way to get it to equal each other.
and get a parameter to work.?????
Any help would be appreciated and thanx in advance for an help.

You need to also open the results table like this:
SELECT * FROM Clients,RESULTS WHERE Clients.AccountID = Results.AccountID
ORDER BY Surname


Hope it helps
-Azzmodan

[Spawny]

Yeah thanx Azzmodan for the help. That solved it.