I can't seem to get a SELECT statement to work when I type it directly into
the row source of a combo box.

I can incorporate the SELECT statement into a Query and then reference the
query but I can't seem to reference the SELECT directly from the row source.
Is it possible or can I only refer to a query.

Thanks
Dave
--
David R. Frick & Co., CPA
http://www.*-*-*.com/

It's possible David -- I do it all of the time. What does your SQL
look like, and what do you mean by "doesn't work"?

For example, in a department table, in the department type field, the
row source is:

SELECT DeptTypeID,DeptType FROM tblDeptType ORDER BY DeptType;

If you use the builder, it puts all manner of brackets and table
prefixes everywhere, which I personally despise <g>. However, either
way works.

Vince
*** Remove NOSPAM to reply ***

Thanks Vince

I went back and tried it and it appears it was syntax errors on my part.

I agree with you about the builder. If I can just write the straight SQL, I
don't seem to have as many problems.

Thanks again for your help.
Dave

David,

It's certainly possible to use an SQL statement directly in the RowSource
property string, so if you are using identical SQL statements for the two
approaches, I'd suspect one of the two following problems:
1.  your SQL statement is too long to fit in the RowSource property (max of
2048 characters), or
2.  your query is sufficiently complex that the performance benefit reaped
from using a saved query avoids some problem that occurs when using the SQL
statement as the RowSource.  (I've never actually seen this occur, although
I've heard others complain of display anomalies occuring when using a
slow-running query as a row source.)

If your SQL statement isn't long enough for #1 to be the problem, you might
consider posting it for examination.  Also, a bit more detail wrt the
behaviour seen when using the SQL statement directly might help in
identifying the problem (e.g.: do you get an error message?  does the combo
box show any data at all?)

Nicole