[AccessD] A2K: Is it possible....?

Darren DICK d.dick at uws.edu.au
Thu Jan 15 23:18:32 CST 2004


Hello all
I have a combo box fed by a simple SQL
Me.cboMycombo.rowsource = "SELECT tblMyTable.* FROM tblMyTable;"
So far so good. If there are 5 items in tblMyTable I expect to see 5 items in the combo box.

Here's the tricky Bit.
Say I want to add a 6th entry that is really just a line of text that is not in the table
A string something like "<None of the Items in this List>" then have the 'real' 5 or so items
from the table in addition to the 1 line of text

Make sense?

Many thanks in advance

Darren



More information about the AccessD mailing list