'No Current Record' Error

[OrWolf]

I'm trying to run a simple query with two tables and a left join. I'm getting a 'No Current Record' error when I attempt to run it. To test it, I removed replaced the left join with a simple join and the query returned multiple records. Any ideas?

 

[link9]

Post the query -- in both forms

 

[OrWolf]

I'm not running the query from a form. I'm just trying the get the query to work first.

 

[link9]

Both forms being the query with the JOIN and the query w/out the JOIN... I think that would help pinpoint the problem.

Paul Prewett

 

[ghubbell]

Hi OrWolf,
I think link9 was asking if you could display the SQL version of this query. I hope he didn't mean post the query in both forUms...that just sends everyone on a wild goose chase. If you go to your query in design view and then select SQL view: copy and paste her in here! Gord
ghubbell@total.net