Unbound vs. Bound Combo boxes

[patman06]

Could one off you fine people that knows a lot more than I do direct me to some information on the pros and cons of using unbound and bound combo boxes. And when to use them? I have been spending a lot of time reading these forums but feel like I have a major gap in the fundamentals of Access.

 

[Simon_MT]

I generally use unbound combi-boxes to be more efficient and then call , for example:

Function LookupClientsCategory()

    With Screen.ActiveControl
        .RowSource = "SELECT [Clients Category].Category, [Clients Category].[Category Desc] FROM [Clients Category] ORDER BY [Clients Category].Category;"
        Call ListDisplay
    End With

End Function

Simon

 

[patman06]

I was referring to the Control Source. I have seen both bound and unbound in snippets of code but without the context of the rest of the code it is hard to figure out. I have continued with the unbound to look up data and bound to change data.
Thanks for the confirmation.