Adding an asterisk to the list of items already in a combo box

A

Access101

I understand that you can add an asterisk to a preexisting list (Query or
Value List) in a combo box by using a UNION query in the rowsource properties
to append the items already in the list with an asterisk as the first item.

Anyone know how to do this?
 
M

MGFoster

Access101 said:
I understand that you can add an asterisk to a preexisting list (Query or
Value List) in a combo box by using a UNION query in the rowsource properties
to append the items already in the list with an asterisk as the first item.

Anyone know how to do this?
Click to expand...

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

SELECT col1, col2
FROM table1

UNION

SELECT "*"
FROM table1

The "FROM table1" in the 2nd SELECT command is necessary so that JET
(Access DB engine) will just return the asterisk.
--
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)

-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv

iQA/AwUBQxS7EYechKqOuFEgEQJ9aACfXGG6lbQsN4PvqEsAggWnRbSJEVEAoNoF
pEM32tqyBroPQP8STyT/V7cZ
=wFcS
-----END PGP SIGNATURE-----
 
A

Access101

Thanks for your help.

Does this look like it should work? I'm getting the Field Name/Header
returned, not the values in the table itself ... and the asterisk isn't
showing up.

strSQL = "SELECT luDepts.Dept" & _
" FROM luDepts" & _
" UNION" & _
" SELECT '*'" & _
" FROM luDepts;"


Me.myCategory.RowSourceType = "Field List"
Me.myCategory.RowSource = strSQL
 
A

Access101

I think I figured it out ... instead of "Field List" I used "Table/Query"

Me.myCategory.RowSourceType = "Table/Query"

Thanks for your time and help.

Thanks,
Michael
 
Top