Combo Box lists

[Guest]

Hi

I have a combo box in which i want to display certain records from a field (
all the Quote Numbers that don't have a job number) i have done this and it
works fine. The problem i have is that i now want to add another record to
that list that appears all the time "QUOTE N//A" for when there isn't a quote
number, if i put this in the tables that are being queried it comes up once
for every time it is chosen.

So what i want is to select value from a table and add "QUOTE N/A" to the
end of that list. Is this possible?

Cheers

Danny

 

[Rich Schoenfeld]

You need to create a union select statement based on your current recordset
and "Quote N/A" and use this as your recordsource for the combo box.

For example:

SELECT "Quote N/A" as jobNumbers, 2 as Sort From tblJobNumbers UNION SELECT
jobNumbers, 1 as Sort FROM tblJobNumbers Order By Sort, jobNumbers

The sort will force Quote N/A to show up at the bottom of the list.

Good Luck,
Rich

 

[Rich Schoenfeld]

I forgot to add that one thing that would solve your original problem as
well would be to use the DISTINCT keyword. This would prevent the multiple
lines you saw.

-Rich

-Rocj