Combo Box - "<Select User>"

[MJ]

I have a combo code that is working well in the selection of the data yet
rather than having a BLANK displaying in the combo box prior to selecting the
value I would like for it to say... <Select User> . Below is the ROW SOURCE
code:

SELECT [User Name], [User Number] FROM tblUsers2 WHERE [User Name] Is Not
Null ORDER BY [User Name];

Thank you in advance,

 

[Gina Whipp]

MJ,

Try...

SELECT [User Name], [User Number] FROM tblUsers2 WHERE [User Name] Is Not
Null ORDER BY [User Name] UNION Select "<Select User>" as Bogus FROM
tblUsers2;

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

 

[Douglas J. Steele]

See whether the section on simulating XP Cue Banners I had in my February,
2004 "Access Answers" column in Pinnacle Publication's "Smart Access" is of
any use to you.

You can download the column (and sample database) for free at
http://www.accessmvp.com/DJSteele/SmartAccess.html