In earlier versions of MS Access you could set the Me.RecourSource property on a Form to a Table name or Query name or your own Select Statement.
Not in MS Access 2010. If you want to set it to a SELECT statement you have to use the FILTER property.

Example:

Me.Filter = “SELECT * FROM Customers WHERE CustomerName = ‘John’ ”
Me.FilterOn = True
Me.Refresh

If you need to customize a dropdown list you can do so programatically by using the ‘Attributes’ setting of the object and specify a CSS style.

VB code example:

DropDownList1.Items.Add(“Choose Red”)
DropDownList1.Items(DropDownList1.Items.Count – 1).Value = “1″
DropDownList1.Items(DropDownList1.Items.Count – 1).Attributes.Add(“style”, “background-color:Red”)

NOTE: you can insert the 3 lines of code above inside a loop that reads the list item Text, Value and style color from a database table.

<%
‘ NOTE: this example is for iPhone and Windows Phone 7 but you can add more devices as follows: Dim x As New Regex(“android|blackberry|nokia|etc…”).

Dim u As String = Request.ServerVariables(“HTTP_USER_AGENT”)

Dim iPhone As New Regex(“iphone”, RegexOptions.IgnoreCase)
Dim WP7 As New Regex(“windows phone”, RegexOptions.IgnoreCase)

If iPhone.IsMatch(u) Then
xScreenWidth = 960
xScreenFontSize = 70
ElseIf WP7.IsMatch(u) Then
xScreenWidth = 300
xScreenFontSize = 22

Else
Response.Redirect(“http://your_desktop_website.com“)
End If

Response.Write(“<div style=’width:” & xScreenWidth & “px; font-size:” & xScreenFontSize & “px;’>”)
%>

<!– Your HTML code here –>

<%
Response.Write(“</div>”)
%>