Need to populate Combo box from values through query and a hard coded value at the same time.

[JackLeon]

Currently I have a combo box in my access 2007 application which is drawing its value through a table using a SQL Query. I would also like it to show up a hard coded value in addition to the current list. Could anyone please help with the same.

[CJ_London]

you would need to create a union query - something like

SELECT myField
FROM myTable
UNION SELECT "HardCodedValue"
FROM MyTable

This assumes your original query returns only one column, if it returns more, you will need to add additional values of the same datatype

[ItsMe]

... I would also like it to show up a hard coded value in addition to the current list...

Not sure it is what you are looking for but you can include literal text within a query like this ...

SELECT QyeryName.FieldName, "Food For Thought" AS MyAlias
FROM QyeryName;

[JackLeon]

Thanks guys.. query from Ajax was what I was looking for.. @Itsme.. actually I was trying to have the values in a single column.. your query would get it in another column.. may be I wasnt very clear with my query.. anyway, thanks for the help.