dynamically set values for a combo box

[striker73]

I want to be able to dynamically set the values for my combo box and I am unclear on the syntax. Statically, I can set the rowsource equal to:

"Client" ; "Facility" ; "Contractor" ; "Regulatory Agency" ; "Laboratory"

However, I want to do this in my code and access doesn't like the semi-colon very much. Any ideas? Thanks!

 

[striker73]

a-HAH! I figured it out. You have to add quotation marks, which VBA doesn't like, so you have to use ascii code like this:

cboContactType.RowSource = Chr(34) & "Client" & Chr(34) & ";" & Chr(34) & "Facility" & Chr(34) & ";" & Chr(34) & "Contractor" & Chr(34) & ";" & Chr(34) & "Regulatory Agency" & Chr(34) & ";" & Chr(34) & "Laboratory" & Chr(34)