combo box query?

racerrunner

Registered User.
Local time
Yesterday, 18:16
Joined
May 29, 2005
Messages
32
Hi all,

I intend to populate a combo box with the value from the table.

Therefore, under the combo box Row Source I write: SELECT distinct Tasks.Task FROM Tasks ORDER BY Tasks.Task;

However, I also want to populate the combo box with additional value that is not found in the table n I dont intend to save this value in the table.

I.E

whenever the form is load this combo box contains

Car //from table
Truck //from table
Bus //from table
Others //hardcode.

Is it possible to combine value from query + hardcode.
The combo box in access does not have a addItem method. Therefore, is it possible???

Thank you
 

Users who are viewing this thread

Back
Top Bottom