Access 2000 RecordSource and left Joined Tables

M

Michael

I have set the RecordSource to select only active or
inactive files from a combo box in my form that part works
great. Except for a few fields in the Foarm SHOW #NAME?
The fields are in tables that are Right joins in the SQL
statement behind the form. How do I get around that.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Two tables for One form 3
brackets in a sql statement 3
combobox question 3
Modify Record source for form with VBA 2
Creating Labels Over 3-Up Image 2
Right Joins and RecordSource Help 0
Record source - "No fields available to be added to the current vi 1
My (final) 2 cents on continuous form design 4

Top