Access Combo Box

[abidshahzad4u]

Hi to all

I am populating a combo box from a table in the Access Form. I have some values in the table which are displaying exactly in the combo box.
I have to add a custome field at the top of the combo box, which is not coming from the table.

How can I do this?

 

[Galaxiom]

The Row Source can be a table or a query so just add the extra values to that query.

 

[ajetrumpet]

if you select a field for the box, you get a COLUMN. if you just want a value to add to the field list that you've already got, i'm not sure if you mesh the two (values and queries). i don't think you can.

 

[Galaxiom]

i'm not sure if you mesh the two (values and queries). i don't think you can.

Surely anything is possible?

SELECT blah blah
UNION ALL
SELECT "whatever" AS Field1....

 

[abidshahzad4u]

Thanks for all

I am getting the values from the same table at which I have insert record. As in my case the type 'parent' is not present in the table. I want to add it at top of the lookup populated from the same table.

 

[Galaxiom]

It would be better to populate the combo's row source from a query on a dedicated lookup table including all possible values. Moreover these records should include numerical IDs and those IDs stored in the main table rather than the text.