If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Creating blank line in look-up table
I want the first space in my drop-down list to be a blank space, how
do I achieve this. The Drop-down list is in a seperate table. |
#2
|
|||
|
|||
Creating blank line in look-up table
if the table has a primary key field that is not seen by the user, plus one
or more fields that show up in the form's combo box droplist, then just add a record to the table with a primary key value and no data in the other field(s). alternately, you could probably use a Union query, for example SELECT Table1.ID, Table1.someName FROM Table1 UNION SELECT Null, "" FROM Table1 ORDER BY Table1.someName; hth "Wendy Simes" wrote in message ... I want the first space in my drop-down list to be a blank space, how do I achieve this. The Drop-down list is in a seperate table. |
Thread Tools | |
Display Modes | |
|
|