SELF POPULATED COMBO ROWS

[Mikmik]

To anyone that can help,
I have created a form having the DefaultValue = Continous Forms.
In the form I have a Combo box based on a table called Mail_List.

I'd like to have as default value, in the first 4 Combo rows, the same predefined names (changeable, if necessary).

Thanks for your help.

Mik

 

[Guest_imported]

In a new column of your RowSource query, put this type of expression

MySort:IIf([YourField] = "Name1" or [YourField] = "Name2" Or [YourField] = "Name3" Or [YourField]= "Name4","A","B&quot

Replace [YourField] with your Field Name, and "Name1-4" with the names you was at the top of the list.

Sort by this field Ascending. That will put your 4 names at the top of the Combo box.

Paul