Combo Box Question

[nancier]

I have a combo box that is set up so I choose from a table field list. Is there any way to have another value or a default value that isn't on the list?
Thanks

 

[perrymans]

Use a Union query, but it has to be done in SQL, not in the QBE (Design View) window.

Sean.

SELECT tblProject.ProjectID AS ID
FROM tblProject WHERE (((tblProject.Inactive)=False))
UNION SELECT "-Add Project-" AS ID FROM tblProject
ORDER BY ID;

 

[TheAceMan1]

How are ya nancier . . . . .

[blue]perrymans[/blue] is on target here. However, not only is it [blue]easier to do in query design view[/blue], but when your done, its a matter of [purple]copying the SQL[/purple] and [purple]pasting it into the RowSource[/purple] of the combobox.. Because of this [blue]I hardly ever write SQL any more.[/blue]

Also have a look at the [blue]Value List[/blue] property. Values in the list are [blue]user defined.[/blue] Character count is limited to 2k (2048) however.

See Ya! . . . . . .