Items for a ComboBox

[Syed Zeeshan Haider]

Hello Experts,
I have Access 97 Pro on Win98SE.

In a simple database, which I developed with the help of Wizards and Help
files, I got following SQL line in Row Source Property field of a ComboBox.

SELECT DISTINCT Query.Credit FROM Books AS Query ORDER BY Query.Credit;

Now I have changed it into following for another database:

SELECT DISTINCT Query.[File No / Ref No] FROM [All Files] AS Query ORDER BY
Query.[File No / Ref No];

When run, it asks for Parameters. I am new to Access. Can somebody explain
its behaviour?

Thank you,

 

[Cheryl Fischer]

I am somewhat concerned about your use of the / mark in your field name.
Access recommends against this in its list of Reserved Words (see bottom of
following article) and indicates that undesirable results may occur.

http://support.microsoft.com/default.aspx?scid=kb;en-us;109312#appliesto

This article refers to Access 1 through 97; however, there is very little
difference in the Reserved Words lists for Access 2000 and forward.

If you do not want to change your field names, you may want to replace:

Query.[File No / Ref No]

with this:

Query![File No / Ref No]

which may "induce" Access to recognize the expression as referring to a
field - it may work.